while for 100 records in source table loaded sucessfully in
trgt table . assume ,session will take 10min or 5 min to
successfully succeeded. then 100 million records r there in
source how much time will take by session to succeeded.
there no fail ok.trgt table will load 100 million records
with out any errors . don't tell perfect time . assume your
self how much time to succeeded?



while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take..

Answer / sri

it depends on system specifications like ram,partitions etc

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Informatica Interview Questions

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers   Hexaware,


What is informatica? What exactly are the practical uses in real world

2 Answers  


If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  


How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,


What is informatica?

0 Answers  






How Union Transformation is an Active Trans?

6 Answers  


how to declare array in plsql?

1 Answers  


difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,


i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,


tell me the informatica architecture

1 Answers   Banca Sella, Wipro,


How can we use mapping variables in informatica? Where do we use them?

0 Answers  


Categories