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 Posted / sri
it depends on system specifications like ram,partitions etc
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is data transformation manager process?
design of staging area?
what is size of u r database?
Describe expression transformation?
Can we override a native sql query within informatica?
What are junk dimensions?
Define filter transformation?
Sequence generator, when you move from develoment to production how will you reset
What are the different options available for update strategy?
Define the various join types of joiner transformation?
What is the need of etl tools?
Tell me about MD5 functions in informatica
What is aggregate cache in aggregator transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the status code in stored procedure transformation?