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 |
When to use normalization transformation other than cobol source?
when we dont use aggregator in mapping ?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
How to recover the standalone session?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
how to work with mapplet designer in informatica?
What can we do to improve the performance of informatica aggregator transformation?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
If we have lookup table in workflow how do you trouble shhot to increase performance?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
what is the function of 'F10' informatica ?