Interested to Buy Any Domain ? << Click Here >> for more details...
why sequence generator should not directly connected to
joiner transformation ?
- 1 Answers
- 10747 Views
- ANZ, I also Faced
- E-Mail Answers
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 is the sql query overwrite in source qualifier in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How we can use union transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Slowly changing dimensions, types and where will you use them
What is meant by a domain?
Different circumstance which drives informatica server to expel records?
Sequence generator, when you move from develoment to production how will you reset
What is deployment group?
Reusable transformation and shortcut differences
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the various types of transformation?
What is a passive transformation?
Describe an informatica powercenter?
