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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informatica?

686


What are roles and groups and benefits of using them?

573


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1612


What is native users?

725


Briefly describe lookup transformation?

603






Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1657


Differentiate between Load Manager and DTM?

1674


What are the advantages of using informatica as an etl tool over teradata?

569


What is complex mapping?

641


What is meant by query override?

640


What is an active transformation?

648


What is the benefit of session partitioning?

601


What are the new features of Power Center 5.0?

1236


What is flashback table ? Advance thanks

1484


Where do we use mapping variables in informatica?

621