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 size of u r database?

0 Answers  


what is unit testing?tell me proceedure

0 Answers   L&T, UST,


What are the two modes of datamovement in informatica sever?

2 Answers  


What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  


What is target update override

2 Answers   CTS,


I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  


What could be the possible resons of locks by user?

0 Answers  


What is Cognos script editor?

0 Answers   Cognizant,


How to create the source and target database connections in server manager?

0 Answers   Informatica,


How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  


Explain pushdown optimization and types in informatica

0 Answers   Informatica,


Categories