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

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  


How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,


What is dimensional table? Explain the different dimensions.

0 Answers  


Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  


Diffrence between static and dynamic cache

2 Answers   HCL,






My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,


Explian the Process of deployment groups in informatica

0 Answers   Informatica,


how many ways can we implement SCD2?

4 Answers   IBM, TCS,


Differentiate between Load Manager and DTM?

0 Answers  


what are the output files that the informatica server creats during running a session?

2 Answers   CTS,


Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,


what r the transformations that r not involved in mapplet?

8 Answers   Wipro,


Categories