col1,col2
101,a
102,b
103,c
104,d
o/p
col1,col2
101,d
102,c
103,b
104,a
************
u can follow theses steps......
import the data.......copy the columns to two transformer using copy stage......trans1 having col1 and trans2 having col2.....sort the col2 using sort stage and add column skey through surrogate key generator..........from trans1 also add column skey through surrogate key generator...join both the columns using column skey.... remove skey from the last o/p stage.....u will get the result
import the data.......copy the columns to two transformer using copy stage......trans1 having col1 and trans2 having col2.....sort the col2 using sort stage and add column skey through surrogate key generator..........from trans1 also add column skey through surrogate key generator...join both the columns using column skey.... remove skey from the last o/p stage.....u will get the result
***********
Use partition technique as Sort & make use of internal sort (stable sort)...
No comments:
Post a Comment