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
Answer Posted / srinivas
Use below stage variables
create 4 stage variables
STG1 =NAME:COMPANY
STG2=1
STG3= IF STG1:STG4 THEN STG3+1 ELSE STG2
STG4= STG1
create extra column for store this ranks.
After this stage use the sort stage to sort the data based on ranking column.
Then will get the exact output what we are looking.
krish IBM 1
pooja TCS 1
nandini WIPRO 1
krish IBM 2
pooja TCS 2
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Explain connectivity between datastage with datasources?
Is possible to create skid in dim,fact tables?
What is the importance of the exception activity in datastage?
explain about citrix scheduling tool in datastage
What is the process of killing a job in datastage?
Could anyone give brief explanation bout datastage admin
Explain Quality stage?
Describe routines in datastage? Enlist various types of routines.
What is the purpose of pivot stage?
What is difference between join, merge and lookup stage?
Define APT_CONFIG in Datastage?
Describe the architecture of datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
What is ds designer?