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 |
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
What is informatica? What exactly are the practical uses in real world
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
What is informatica?
How Union Transformation is an Active Trans?
how to declare array in plsql?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
tell me the informatica architecture
How can we use mapping variables in informatica? Where do we use them?