Explain about Sequence Generator Transformation.
Sequence Generator Transformation is a passive transformation which allows you to generate sequence numbers which are to be treated as primary keys
A Surrogate key is a system generated sequence number which are used as dimensional keys or artificial keys or synthetic keys
A Sequence Generator Transformation is created with default output ports
1. NEXTVAL (generates a sequence of numbers by connecting it to a transformation or target)
2. CURRVAL (is the NEXTVAL value plus one or NEXTVAL plus the increment by value.)
This transformation doesn't allow you to create new ports or edit the existing ports
Set the following properties to generate sequence numbers
1. Start Value (zero)
2. Current Value (one)
3. Increment by (one)
Sequence Generator Transformation is a passive transformation which allows you to generate sequence numbers which are to be treated as primary keys
A Surrogate key is a system generated sequence number which are used as dimensional keys or artificial keys or synthetic keys
A Sequence Generator Transformation is created with default output ports
1. NEXTVAL (generates a sequence of numbers by connecting it to a transformation or target)
2. CURRVAL (is the NEXTVAL value plus one or NEXTVAL plus the increment by value.)
This transformation doesn't allow you to create new ports or edit the existing ports
Set the following properties to generate sequence numbers
1. Start Value (zero)
2. Current Value (one)
3. Increment by (one)
No comments:
Post a Comment