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
- 12280 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
Can you explain players in datastage?
What is a merge?
What are the repository tables in datastage?
What is ibm datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How do you import and export the datastage jobs?
Define repository tables in datastage?
What are orabulk and bcp stages?
What are the important features of datastage?
What are the steps required to kill the job in Datastage?
What are the areas of application?
Where the datastage stored his repository?
On which interface you will be working as a developer?
Nls stands for what in datastage?
What is the purpose of interprocessor stage in server jobs?
