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
- 12571 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
What is the difference between informatica and datastage?
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 active and passive stage?
How many types of hash files are there?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the stages in datastage?
why do u need the IOS upgradation in a FC switch
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How do u convert the columns to rows in datastage?
What are the types of jobs we have in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What are the some differences between 7.x and 8.x version of datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
What are the important features of datastage?
Lookup constraints
