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 Session and Batches?
What do you mean by filter transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain what are the different versions of informatica?
What is transformation?
What is informatica worklet?
What is joiner transformation in informatica?
Design a mapping to load a target table with the following values from the above source?
How might you approve all mappings in the archive all the while?
What are the types of data warehouses?
What is lookup change?
Sequence generator, when you move from develoment to production how will you reset
What is event and what are the tasks related to it?
What is sequence generator transformation in informatica?
What are mapplets? How is it different from a Reusable Transformation?