etluser

 Profile Answers by etluser 

• Jan 2nd, 2010

 

Here are the steps

1. Assume that there are four departments and that the source is a source file that contains dept id.
2. Create four Sequence Generator transformations.
3. Create an expression transformation, configuration is as below- 
a. It will have an input port as the dept id from the source file.
b. It will have an output port as dept_seq_no.
c. This port value is set based on dept_id value using decode function.
d. Decode function should refer the NEXTVAL port values in the four Sequence Generator transformations.