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
- 12325 Views
- I also Faced
- E-Mail Answers
Answer Posted / sankar
use aggregator stage take count(*) group by name
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Give an idea of system variables.
Terminate Activity
What are the various kinds of containers available in datastage?
State the difference between an operational datastage and a data warehouse?
how to implement scd2 in datastage 7.5 with lookup stage
Define APT_CONFIG in Datastage?
Is possible to create skid in dim,fact tables?
How many areas for files does datastage have?
options available in sequence job to run,validate?
Difference between server jobs & parallel jobs?
What are the steps required to kill the job in Datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
What are the types of containers in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how can we create rank using datastage?what is the meaning of rank?
