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


Please Help Members By Posting Answers For Below Questions

What are the databases that informatica can connect to windows?

824


What is Session and Batches?

888


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

1933


What is the scenario which compels informatica server to reject files?

851


What does cheating measurement mean?

823


What is the cumulative sum and moving sum?

982


What is difference between a gateway node and worker node?

889


without table how to come first record only in oracle?

2058


State the differences between sql override and lookup override?

885


What is joiner change?

932


Is it possible to define a single node as a Gateway node as well as worker node?

936


How can we store previous session logs?

804


How to load the data from a flat file into the target where the source flat file name changes daily?

827


Explain where to store informatica rejected data? How to extract the informatica rejected data?

839


What are the basic requirements to join two sources in a source qualifier transformation using default join?

836