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
- 11945 Views
- I also Faced
- E-Mail Answers
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
How and where you used hash file?
What are some prerequisites for datastage?
Explain ibm infosphere information server and highlight its main features?
How to find value from a column in a dataset?
How can one find bugs in job sequence?
Name the third party tools that can be used in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are constraints and derivations?
explain about citrix scheduling tool in datastage
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
If you want to use a same piece of code in different jobs, how will you achieve this?
How a source file is populated?
What is usage analysis in datastage?
What is job control?
what is the use of materialized view?
