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 |
Can we override a native sql query within informatica?
How to load duplicate records in to a target table which has a primary key?
Types of error logs in Informatica?
How are parameters defined in informatica?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What is confirmed dimension and fact?
what r the transformations that r not involved in mapplet?
what r the values tht r passed between informatics server and stored procedure?
what is left outer join?
What are the components of Informatica? And what is the purpose of each?
How many input parameters can exist in an unconnected lookup?
Write the unconnected lookup syntax?