Sree.nivas

 Profile Answers by Sree.nivas Questions by Sree.nivas

• Oct 1st, 2007

If we  use same sequence generator for multiple times to load the data at same time there will be DEAD LLOCK occurs.To avoid  Dead locks we dont use same sequence generator

Rich

• Nov 17th, 2006

You can use sequence generator,but is the usein the mapping,it create not unique value

Answer Question  Select Best Answer

We are planning to move from Informatica 6.1 to 8.1. I need to know the steps/guide for upgrading the repository.It is possible to go from version 6 to version 8 directly or we have to move to version 7 and then version 8

ansar

• Oct 4th, 2007

Hi Ahmed,Did you ever get the steps how to upgrade from 6.x to 8.x. If Yes please can you send it over to me, it will be of great help to me. U might receive my email but its ansaar02@yahoo.com or arshads_02@yahoo.com.Thanks a lot in Advance.RegardsAnsar.

Answer Question  Select Best Answer

naina

• Oct 6th, 2007

The mapplets cant use these following transformationsxml source qualifiernormalizernon-reusable sequence generator (it can use only reusable sequence generator)

Answer Question  Select Best Answer

NO. Informatica is not at all concern with back end data base.It displays u all the information that is to be stored in repository.If want to reflect back end changes to informatica screens, again u have to import from back end to informatica by valid connection.And u have to replace the existing files with imported files.

Tapas

• Oct 6th, 2007

It does matter if you have SQL override - say in the SQ or in a Lookup, you override the default sql. Then if you make a change to the underlying table in the database that makes the override SQL inco...

vidyanand

• Aug 4th, 2006

Yes, It will be reflected once u refresh the mapping once again.

Answer Question  Select Best Answer

halgai

 Profile Answers by halgai Questions by halgai

• Oct 8th, 2007

Design a trap to a file or table by the use of a filter transformation or a router transformation. Router works well for this.

ravi kumar guturi

• Oct 5th, 2005

correction the rejected data and send to target relational tables using loadorder utility. Find out the rejected data by using column indicatior and row indicator.

Answer Question  Select Best Answer

What condition should be specified in the Router transformation expression editor to get unique rows, duplicate rows and null values on a particular column in 3 different target databases?

I have multiple servers, I want to assign a work flow to multiple servers

krishna

• Oct 19th, 2007

Informatica server will use Load manager process to run the workflow,load manager will do? assign the workflow process to the multiple servers.

Answer Question  Select Best Answer

sai kiran

• Oct 20th, 2007

If possible using Lookup will give better performance over joiner.Using lookup we can perform?outer joins, equi, and non equi joins.Using joiner we can perform only equi joins.In lookup we can also write SQL ovverrides.

guy.sridhar

 Profile Answers by guy.sridhar Questions by guy.sridhar

• Oct 15th, 2007

The exact difference is, by using joiner we can get both matching and unmatching records from the table .By using look up we can find out whether the records exists or not.and other thing we can ...

Answer Question  Select Best Answer

The source file is FTP'ed daily and it is appended with mmddyyyy. How do i specify the file name in the Source connection present in Informatica session

Mamatha

• Oct 24th, 2007

I hope it will work. You have to give this command in the pre session command /_`date "+%d%h%Y" | awk '{print toupper($0)}'`.txtThanksMamatha

Answer Question  Select Best Answer

Informatica server is in Unix environment and other server is in Windows environment. I have to connect informatica server to other server .I am taking external procedure transformation in informatica to connect both servers.Is it possible to connect both servers by using Ext. Proc. Transformation?If it is possible , how to take DLL from other server to informatica external procedure transformation?

mahindra

• Oct 31st, 2007

Hi,The solution provided is correct. I would like to add more information into it.Reusable Sequence Generator is a must for a Mapplet:Mapplet is basically to reuse a mapping as such if a non- reusable...

PHILIP

• Jun 11th, 2007

Hi Question is, Are you sure its going to start with the 1000 number after the 999. By default for reusable SEQUENCE, it has a cache value set to 1000, that's why it takes 1000 else if you only have 5...

Answer Question  Select Best Answer

I have a requirement to lookup the same table twice with different keys one after another. If the first lookup fails then only the second lookup should be done. And, i have to use connected lookup to return multiple output ports. Any idea how to do?

U can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. U need matching keys to join two relational sources in source qualifier transformation.Where as u doesn’t need matching keys to join two sources. Two relational sources should come from same datasource in sourcequalifier.U can join relatinal sources which r coming from diffrent...

divakar

• Nov 5th, 2007

source qualifier is used for reading the data from the database where as joiner transformation is used for joining two data tables.source qualifier can also be used to join two tables but the conditio...

pkonakalla

 Profile Answers by pkonakalla Questions by pkonakalla

• May 23rd, 2007

hi, as per my knowledge, you need matching keys to join two relational sources both in Source qualifier as well as in Joiner transformation. But the difference is that in Source qualifier, both the keys must have primary key - foreign key relation, Whereas in Joiner transformation its not needed.

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Nov 14th, 2007

You can use the Repository Manager to perform the following tasks:Add or remove a repository.Work with repository connections. Search for repository objects or keywords.View object dependencies. Compa...

obli prabu KV

• Oct 28th, 2007

Using repository manager*We can create folders under the repository*Create Sub Folders and Folder Management*Create Users and USer Groups*Set Security/Access Privilges to the usersand many more... 

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Nov 14th, 2007

Pre-session:Before executing session, this pre-session command executesPost-session:After the completion of execution of this session, the script in the post-session runs.

Answer Question  Select Best Answer

Hi guys,I have a question why my Informatica PowerCenter Workflow Manager does not show the repository anymore. I can't connect it because the screen is totally blank. The connect and disconnect tools can't be clicked. The only thing i can click is Add. So, how can i make it work again? This suddenly happens like that.

priyagambhir

 Profile Answers by priyagambhir Questions by priyagambhir

• Nov 15th, 2007

Its very simpleGoto View Menu OptionSelect Navigator..it will start showing the repository windowregards

vijay_00891

 Profile Answers by vijay_00891 Questions by vijay_00891

• Apr 16th, 2007

When u create a repository it must showup in Workflow manager Or else u can add a Repository by clicking the add button in workflow manager then u will be asked for repository name and username. Type ...

Answer Question  Select Best Answer