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 |
What are the different threads in DTM process?
What is a filter transformation and why it is an active one?
What is the difference between Bulk Load and Normal Load
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
What is the use of transformation?
what r the values tht r passed between informatics server and stored procedure?
what is the use of Java Transformation in Informatica 8.x?
Partition, what happens if the specified key range is shorter and longer
What are the limitations of joiner transformation?
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?
Which development components of informatica have the highest usage?
How might one distinguish in the case of mapping is right or not without associating session?