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
- 12211 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
Differentiate between Join, Merge and Lookup stage?
What is the differentiate between data file and descriptor file?
What are constraints and derivations?
What is a datastage job?
What is a merge in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the various kinds of containers available in datastage?
Give an idea of system variables.
What are the partitioning techniques available in link partitioner?
Distinguish between informatica & datastage. Which one would you choose and why?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the components of ascential data stage?
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
What is ibm datastage flow designer?
How will you move hashed file from one location to another location?
