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 databases that informatica can connect to windows?
What is Session and Batches?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is the scenario which compels informatica server to reject files?
What does cheating measurement mean?
What is the cumulative sum and moving sum?
What is difference between a gateway node and worker node?
without table how to come first record only in oracle?
State the differences between sql override and lookup override?
What is joiner change?
Is it possible to define a single node as a Gateway node as well as worker node?
How can we store previous session logs?
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the basic requirements to join two sources in a source qualifier transformation using default join?