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
- 10124 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
what is use of SDR function?
Why fact table is in normal form?
What is the difference between operational data stage (ods) and data warehouse?
How the ipc stage work?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How one source columns or rows to be loaded in to two different tables?
How many Key we can define in remove duplicate stage?
What is the difference between hashfile and sequential file?
Differentiate between datastage and informatica?
What is the roundrobin collector?
What is data partitioning?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How you can fix the truncated data error in datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
how to abort the job its matain duplicates?
