Scenario:
a. Design a job where we read the data from squential file.
b. Analyze the data into job and generate these 3 columns
Example Input:
| Data |
| Gama |
| Charlie |
| Alpha |
| Beta |
| Alpha |
| Charlie |
| Delta |
| Alpha |
Output Expected:
| Data | ROW_NUMBER | RANK | DENSE_RANK |
| Alpha | 1 | 1 | 1 |
| Alpha | 2 | 1 | 1 |
| Alpha | 3 | 1 | 1 |
| Beta | 4 | 4 | 2 |
| Charlie | 5 | 5 | 3 |
| Charlie | 6 | 5 | 3 |
| Delta | 7 | 7 | 4 |
| Gama | 8 | 8 | 5 |
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://groups.google.com/forum/#!forum/datagenx
http://datastage4you.blogspot.in/
ReplyDelete??
ReplyDelete