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
What is joiner transformation in informatica?
How do you load alternate records into different tables through mapping flow?
Can we create two repositories on same database instance in oracle?
What are the different components of powercenter?
How many ways are there to create ports?
How does a rank transform differ from aggregator transform functions max and min?
What is meant by lookup transformation?
Explain sessions?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Explain what transformation and how many are there in informatica?
Mention few advantages of router transformation over filter transformation.
How can we delete duplicate rows from flat files?
What is Index Caches size?
Do you find any difficulty while working with flat files as source and target?
What is the function of union transformation?