Answer Detail: RE: Sequence Generator

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: Sequence Generator

Answer: Why sequence generator is not directly connected to joiner transformation?

July 07, 2009 05:09:33	#3
sahan	Member Since: July 2009 Total Comments: 10
RE: Sequence Generator
In general sequence generator is used to create unique values. Suppose if you connect sequence generator to the joiner, after generating numbers to the joiner, aging the joiner will split according to the join condition, it may give matching rows or unmatching rows, then the number of rows is going to change.