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 snowflake schema?
What is repository manager?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is Index Caches size?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to load the data from a flat file into the target where the source flat file name changes daily?
During the running session, output files are created by informatica server. Enlist few of them.
differences between service based and product based?
Explain lookup transformation source types in informatica
What are the types of caches in lookup?
What is aggregator transformation in informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com