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 |
explain different types of modeling.
what are presession,postsession success and postsession failure commands ?
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
What is the command used to run a batch?
Do you find any difficulty while working with flat files as source and target?
What are the active and passive transforamtions?
Howmany ways yoU can update a relational source defintion and what are they?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
What are active transformations? Name them.
Why do we need informatica?
What is enterprise data warehousing?