IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,


After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,


why union transformation is active transformation?

6 Answers   IndiGo, TCS,


What is a router transformation?

0 Answers  


write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,






without matching columns in two tables. how can you join

5 Answers   BirlaSoft,


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 is a command that used to run a batch?

2 Answers  


Explain the different kinds of facts.

0 Answers  


What is the Hierarchy of DWH?

1 Answers  


Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,


What is the meaning of decode in informatica?

0 Answers  


Categories