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
Can you explain players in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the some differences between 7.x and 8.x version of datastage?
How to clean the datastage repository?
sed,awk,head
What are the main features of datastage?
What is the purpose of pivot stage and types of containers in datastage
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the processing stages?
What are the repository tables in datastage?
What are the functionalities of link collector?
Explain ibm infosphere information server and highlight its main features?
How do you import and export the datastage jobs?
What are the types of containers in datastage?
What is the purpose of pivot stage?