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
- 12357 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
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the difference between account and directory options ?
Terminate Activity
Define APT_CONFIG in Datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
Difference between data warehousing and olap?
What is difference between symmetric multiprocessing and massive parallel processing?
Differentiate between hash file and sequential file?
What are sequencers?
Can you implement SCD2 using join, transformer and funnel stage?
How do you register plug-ins?
Highlight the main features of datastage?
What is the command line function to import and export the ds jobs?
What is difference between server jobs & parallel jobs?
Does datastage support slowly changing dimensions ?
