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 |
How to load duplicate records in to a target table which has a primary key?
What is a sorter transformation?
which one is better performance wise joiner or look up
How many numbers of sessions can one group in batches?
What are teh different tasks that can be created in workflow manager?
Tell me one complex query in oracle ?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
What do you mean by blocking transformation?
how to join the two flatfiles using the joiner t/r if there is no matching port?
What are the uses of etl tools?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
How will you convert rows into columns or columns into rows