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
- 12336 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
Differentiate between data file and descriptor file?
What are stage variables, derivations and constants?
What are the processing stages?
What is the process of killing a job in datastage?
What is merge stage?
What are the main features of datastage?
Differentiate between datastage and informatica?
options available in sequence job to run,validate?
What is the difference between server job and parallel jobs?
What are stage variables?
How to perform incremental load in datastage?
what is the use of skid in reporting?
What is the difference between datastage and datastage tx?
What are the benefits of datastage?
what is flow of project?
