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 the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,


What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,


Explain target update override in informatica

0 Answers   Informatica,






How to join three sources using joiner?

0 Answers  


I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,


HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,


Explain what are the different types of transformation available in informatica.

0 Answers  


write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,


followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,


Categories