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
What do you understand by SOA of Informatica?
What is the need for an etl tool?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How we can create indexes after completing the load process?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What the difference is between a database, a data warehouse and a data mart?
What are active transformations.
What is rank transformation in informatica
How to create or import flat file definition in to the warehouse designer?
What are the different types of transformation available in informatica.
How to improve the performance of a session using sorter transformation?
What is the commit type if you have a transaction control transformation in the mapping?
What are the limitations of joiner transformation?