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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sree
Each sequence generator generates numbers depending on
their start value and incrementby value.
If you are using reusable sequence generator and expression
trans is in between target and reusble sequence generator,
then all targets will be populated with the same sequence
numbers.
| Is This Answer Correct ? | 2 Yes | 2 No |
COM components can be used in Informatica
what are the difference between Informatica 7.1 and 8.1?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Mention few power centre client applications with their basic purpose?
What is the capacity of power cube?
How do you handle two sessions in Informatica
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
what is metadata?
replace multiple spaces with single space.
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
Two Default User groups created in the repository are ____ and ______
What is parameter file?