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



2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence genera..

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

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence genera..

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

Post New Answer

More Informatica Interview Questions

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,


Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,


How to enter same record twice in the target table,explain?

7 Answers  


how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,


What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,






What is a dimensional model?

0 Answers  


source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,


What is a repository manager?

0 Answers  


How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,


what is mapping override?

2 Answers   Cap Gemini,


how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,


what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,


Categories