without dynamic lookup how to insert new rows and update
existing rows?



without dynamic lookup how to insert new rows and update existing rows?..

Answer / venubyna1

using Update strategy

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Informatica Interview Questions

How do you migrate data from one environment to another?

0 Answers  


What is the need of building a data warehouse?

2 Answers  


While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,


What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,


every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,






a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,


What is an active transformation?

0 Answers   Informatica,


What is decode in informatica?

0 Answers  


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,


I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,


Categories