why sequence generator should not directly connected to
joiner transformation ?
Answer Posted / srinu
Mainly sequence generator is used to generate an unique id
dynamically.
We can not join this number against any column in other
tables...
So.. we can not connect sequence generator with joiner.
and also,
Main reason is joiner is a Active transformation.Means it
can alter the number of rows.
So, if u connect sequence generator with joiner the outcome
sequence will not be proper.
Any Queries or Corrections
'srinu.srinuvas@gmail.com'
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
What are the modules in Power Center
update strategy transformation in informatica
define galaxy repository in informatica
How are indexes created after completing the load process?
What is the status code in stored procedure transformation?
Global and Local shortcuts. Advantages.
What is parallel processing in informatica?
Which transformation is needed while using the Cobol sources as source definitions?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to do unit testing in informatica?
How can we delete duplicate rows from flat files?
On which transformations you created partitions in your project?
Write the unconnected lookup syntax and how to return more than one column.
What are the types of data warehouses?
What are the different types of olap? Give an example?