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
Answer Posted / abc
we can use aggregator stage.. nad group on the basis of name and company...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is apt_config in datastage?
What are the different kinds of views available in a datastage director?
How you can fix the truncated data error in datastage?
which r the connectors used in san?
options available in sequence job to run,validate?
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
what is flow of project?
Define Data Stage?
How one source columns or rows to be loaded in to two different tables?
What are sequencers?
I have a few records just I want to store data in to targets cycling way how?
What is the purpose of pivot stage?
What is job control?
What is the difference between orabulk and bcp stages?
What all are the different way to run a job?