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

can anyone suggest best free Talend data integration training online

0 Answers  


how we can update a target table without update strategy and update override?

3 Answers   TCS,


When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  


My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,


I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  






What are the reusable transforamtions?

2 Answers  


wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,


LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  


In target table how to display the system time

1 Answers  


Write the program through which the records can be updated?

0 Answers  


How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,


what happens when a batch fails?

3 Answers  


Categories