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 / anand
we can use aggregator stage to count the repeated records and WHERE AGGREGATION TYPE:COUNT ROWS
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of pivot stage?
How do you generate sequence number in datastage?
What are the job parameters?
What is ibm datastage flow designer?
What are the features of datastage flow designer?
How to reverse the string using unix?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the primary usages of datastage tool?
What is the difference between datastage and informatica?
Why fact table is in normal form?
What are stage variables and constants?
sed,awk,head
Terminate Activity
What are the different plug-ins stages used in your projects?
Where do the datastage jobs get stored?