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
- 11950 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
what is the difference between == and eq in UNIX shell scripting?
What is ds designer?
How to RD using transformer?
Highlight the main features of datastage?
What is the roundrobin collector?
Explain usage analysis in datastage?
What is difference between join, merge and lookup stage?
What are the primary usages of datastage tool?
What are the processing stages?
Lookup constraints
What are stage variables and constants?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How do you reject records in a transformer?
What are datastage sequences?
