without dynamic lookup how to insert new rows and update
existing rows?
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
How to load duplicate records in to a target table which has a primary key?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
What are the components of Informatica? And what is the purpose of each?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the capacity of power cube?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
What is decode in informatica?
How we can confirm all mappings in the repository simultaneously?