Interested to Buy Any Domain ? << Click Here >> for more details...
souce file having the columns like
name company
krish IBM
pooja TCS
nandini WIPRO
krish IBM
pooja TCS
if first row will be repeat i want the result like this
name company count
krish IBM 1
pooja TCS 1
nandini WIPRO 1
krish IBM 2
pooja TCS 2
- 9 Answers
- 12312 Views
- I also Faced
- E-Mail Answers
Answer Posted / reddymkl.dwh
SeqFile---->Sort---->Trms---->Dataset
Sort_Stage: Key=Company (Or) Name
Trms
----------
SV=Company
SV1= If dslink.Company=SV Then SV+1 Else 1
Add (count) column in Transformer stage
Map SV1 stage variable to Count column (SV1=Count)
Will get desired output..
Plz correct me if am wrong....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
To see hidden files in LINIX?
How one source columns or rows to be loaded in to two different tables?
What is job control?
Explain datastage architecture?
how to export or import the jobs in .ISX file
How to RD using transformer?
Enlist various types of routines in datastage.
What is active and passive stage?
Why do we use link partitioner and link collector in datastage?
Nls stands for what in datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Give an idea of system variables.
Difference between server jobs & parallel jobs?
What are the stages in datastage?
Define Routines and their types?
