y.dilip

 Profile Answers by y.dilip 

• Apr 7th, 2009

 

Generally Sequence Generators are connected to the targets to minimize the wastage of the generated numbers.

itisanimesh

 Profile Answers by itisanimesh 

• Jun 18th, 2009

 

Sequence generator transformation is basically used to generate a unique number for each record which is updated or inserted in the target table. Also it is used if we want to create a unique key in the table and on the basis of this unique key we are going to identify the record within the table. this is the same as the concept of primary key of the table.

sahan

 Profile Answers by sahan 

• Jul 16th, 2009

 

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.

itisanimesh

 Profile Answers by itisanimesh 

• Aug 6th, 2009

 

In Addition to previous answer


Sequence Generator transformation is a Passive and Connected transformation. It is used to create unique primary key values or cycle through a sequential range of numbers or to replace missing keys.

It has two output ports to connect transformations. By default it has two fields CURRVAL and NEXTVAL(You cannot add ports to this transformation). NEXTVAL port generates a sequence of numbers by connecting it to a transformation or target. CURRVAL is the NEXTVAL value plus one or NEXTVAL plus the Increment By value.

manoj_pathak

 Profile Answers by manoj_pathak 

• Sep 30th, 2009

 

Remember Joiner tx can accept input from only 2 pipelines.

Now only following 2 scenerios possible to have both joiner and Seq Gen tx:
1)2 input pipelines are already connected and then we want to connect Seq Gen to joiner: In this scenerio, the input from Seq Gen will be a input from third pipeline thus, informatica will thro error on that.

2)Only 1 input pipeleine is connected and we want to connect Seq Gen: In this case, ifnromatica will allow you to connect the Seq Gen but then u wont have the mathing CONDITION. thus, this scenerio is practically impossible.

So, both the above scenerios of having Seq Gen with Joiner arent PRACTICALLY possible.

Thanks,
Manoj