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
how we can load rejected record's at run time?(not through bad files)
What is dynamic cache?
Explain what transformation and how many are there in informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to create the source and target database connections in server manager?
explain one complex mapping with logic? sales project?
What are active transformations.
What are the features of complex mapping?
What is informatica worklet?
How might you approve all mappings in the archive all the while?
What do you mean by enterprise data warehousing?
What is option by which we can run all the sessions in a batch simultaneously?
What is the function of aggregator transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How many transformations can be used in mapplets.