Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6297 Views
- Emphasis, I also Faced
- E-Mail Answers
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 the difference between source qualifier transformations source filter to filter transformation?
Tell me about MD5 functions in informatica
How do you load unique records into one target table and duplicate records into a different target table?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is a standalone command task?
Enlist few areas or real-time situations where informatica is required.
What is target designer and target load order?
What is mapplet in informatica?
How do you promote a non-reusable transformation to reusable transformation?
What is the need of etl tools?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
what is the complex transformation you used in informatica
Define update strategy?
Differentiate between source qualifier and filter transformation?
How to do unit testing in informatica?
