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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a connected transformation?
What if the source is a flat-file?
What is informatica powercenter repository?
What is mapping debugger?
What do you understand by a term domain?
Explain what transformation and how many are there in informatica?
What is joiner transformation in informatica?
Write the advantages of partitioning a session?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to extract sap data using informatica?
Have you worked with/created Parameter file
What is the Process to creating lookup transformation in informatica
What is Session and Batches?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?