why sequence generator should not directly connected to
joiner transformation ?



why sequence generator should not directly connected to joiner transformation ?..

Answer / 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

More Informatica Interview Questions

what is parallel querying and what r hints.

1 Answers  


What is a dimensional model?

0 Answers  


List the transformation in informatica.

1 Answers   TCS,


How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,


wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  






How to generate the HTML output using Informatica.

3 Answers   Wipro,


Separate from an archive server and a powerhouse?

0 Answers  


What are connected or unconnected transformations?

0 Answers   Informatica,


in performance wise union is past,union all is past

2 Answers  


What is joiner transformation in informatica?

0 Answers  


What is workflow monitor?

0 Answers  


Types of error logs in Informatica?

2 Answers  


Categories