2,if we have 3 pipeline containing 3 targets and each target
is connected with diff sequence generator ,let us assume
first target is populated with seq no1-9,so what would be
the number generated by other two sequence generator?what is
the diff in o/p if when we use reusable sequence
generator?what would be the diff if we place expression in
between target and sequence generator?
Answer Posted / ankur saini er.ankur861@gmail.
if we have diff seq gen for each target all three will
generate their independent seq to the targets depending
upon their current and inc valuses(what you configure)..
say 1-9 for target 1 . 1-9 for target 2 and 1-9 for target
3.
but if we are using reusable seq gen..then the seq divided
into the 3 targets ...exp 1-3 will go for target 1 then 4-6
will go to target 2 and 7-9 will go to target 3....it may
vary what target gets what seq.this is just an exapmle to
cliarify that whi seq will get distributed among the targets
Thanks
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are junk dimensions?
What are the types of presistent cache in look up tr.
What is a passive transformation?
How to do unit testing in informatica? How to load data in informatica ?
what is Active lock explain
How big was your fact table
How to elaborate tracing level?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Clarify the aggregator change?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are active and passive transformations?
hi real timers . iam waiting for ur reply regarding ETL TESTING
wat are deployement groups in informatica, how it will be used for developers
How many number of sessions can one group in batches?