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 |
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
What are the prerequisite tasks to achieve the session partition?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
How will you convert rows into columns or columns into rows
How do you change a non-reusable transformation to reusable transformation?
what are the types of facts with Examples?
what is the difference between Informatica 7.1 and Abinitio?
What are junk dimensions?
whether Sequence generater T/r uses Caches? then what type of Cache it is
we have to use order by,where,having we to implement sql query