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 a surrogate key?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Did u used latest transformations of 8.6.0? for what?
Tell me about Propagate functions in informatica
Define mapplet?
Explain dynamic target flat file name generation in informatica
Clarify the utilization of aggregator cache record?
Define enterprise data warehousing?
What are the static cache and dynamic cache in informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
what is the Default Source Option For Update Strategy Transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?