Sequence Generator Transformation is Connected and Passive Transformation. It is used to generate the sequence numbers of our choice. If we want to set seq no from 1 to 100 or 200 to 300 its completely up to us or as per the requirement.
Steps to create a sequence generator transformation :-
- Go to the mapping designer tab in power center designer.
- Click on the transformation in the toolbar and then on create.
- Click on the transformation in the toolbar and then on create.
- Edit the sequence generator transformation, go to the properties tab and configure the options.
- To generate sequence numbers, connect the NEXTVAL port to the transformations or target in the mapping.
Steps to create a sequence generator transformation :-
- Go to the mapping designer tab in power center designer.
- Click on the transformation in the toolbar and then on create.
- Click on the transformation in the toolbar and then on create.
- Edit the sequence generator transformation, go to the properties tab and configure the options.
- To generate sequence numbers, connect the NEXTVAL port to the transformations or target in the mapping.
No comments:
Post a Comment