why sequence generator should not directly connected to
joiner transformation ?
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 |
what is parallel querying and what r hints.
What is a dimensional model?
List the transformation in informatica.
How to read data from flat file source if the data is in paragraph format?
wat s mapping parameter and mapping variable? how do you set that in a mapping?
How to generate the HTML output using Informatica.
Separate from an archive server and a powerhouse?
What are connected or unconnected transformations?
in performance wise union is past,union all is past
What is joiner transformation in informatica?
What is workflow monitor?
Types of error logs in Informatica?