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
- 11965 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 the use of surogate key in datastage
What is the use of datastage designer?
What is the difference between account and directory options ?
How you Implemented SCD Type 1 & Type 2 in your project?
What are system variables and sequencers in datastage
What are the different plug-ins stages used in your projects?
Is possible to create skid in dim,fact tables?
What are the job parameters?
Differentiate between validated and Compiled in the Datastage?
Explain entity, attribute and relationship in datastage?
How can one find bugs in job sequence?
What are data elements?
Differentiate between datastage and datastage tx?
How many types of sorting methods are available in datastage?
What is the difference between passive stage and active stage?
