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?
Answer / sri
it depends on system specifications like ram,partitions etc
| Is This Answer Correct ? | 5 Yes | 0 No |
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
If I have a index defined on target table and if set it to bulk load will it work ?
How will you display "Mr" for male & "Mrs" for female in target table?
What is router transformation
what is the difference between onsite & client site?
Diff b/w ShortCut and reusabel Object ?
hw cn v elimate dublicate values from lookup without overriding sql?
What are Business Components in Informatica?
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
How is union transformation utilized?
how do u tune queries?
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…….