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 |
how to load only the first and last record of a flat file into the target?
without matching columns in two tables. how can you join
Differentiate between a repository server and a powerhouse?
What are the databases that informatica can connect to windows?
State the limitations where we cannot use joiner in the mapping pipeline?
Can we create out put ports in source qualifier t/r?
My source table having some records ,i want load 1st record and last record into one target?
what is data driven?
What is event and what are the tasks related to it?
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
What is the need for an etl tool?
select count(1) from emp? what is the o/p?