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
- 12276 Views
- I also Faced
- E-Mail Answers
Answer Posted / disney
first sort the both name and compamy and then,
using stage variable in transformer:
curr= name:company
val=if curr <> prev then 1 else val+1
prev=curr
o.p = val
name,company,val
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How to clean the datastage repository?
Can you explain players in datastage?
How many types of hash files are there?
Differentiate between hash file and sequential file?
How many areas for files does datastage have?
How do u convert the columns to rows in datastage?
How a routine is called in datastage job?
How do you remove duplicate values in datastage?
What are iconv and oconv?
In Datastage, how you can fix the truncated data error?
Lookup constraints
What are the main features of datastage?
Difference between sequential file and data set?
what is the use of surogate key in datastage
What is the purpose of pivot stage?
