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
Define joiner transformation?
What is workflow monitor?
Global and Local shortcuts. Advantages.
tell me 5 session failure in real time how can you solve that in your project?
How do you promote a non-reusable transformation to reusable transformation?
What are the features of complex mapping?
What is the use of code page?
Where are the source flat files kept before running the session?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain pushdown optimization $pushdownconfig parameter - informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Performance tuning( what you did in performance tuning)
Explain the different kinds of facts.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Is stop and abort are same in informatica?