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

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,


what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,


Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  


What are the components of workflow manager?

0 Answers  






how did u understand business requirement?

2 Answers   TCS,


How to Create a folder using pmrep command?

0 Answers  


What is the functionality of update strategy?

2 Answers  


How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,


if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,


How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  


how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,


Categories