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 a merge?
What is the use of datastage designer?
Name the third party tools that can be used in datastage?
Define data aggregation?
What a datastage macro?
Explain how a source file is populated?
What is staging variable?
How many types of stage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Highlight the main features of datastage?
How a server job can be converted to a parallel job?
Which warehouse using in your datawarehouse
What are the types of containers and how to create them?
What are the steps needed to create a simple basic datastage job?
Have you used Unstructured data?