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
Why do we use exception activity in Datastage?
Is it possible to query a hash file?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
root tree will find which is server job and which is parallel job?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How to read multiple files using a single datastage job if files have the same metadata?
whom do you report?
What are transforms and what is the differenece between routines and transforms?
What is the process of killing a job in datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
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?
How you can fix the truncated data error in datastage?
what is the difference between == and eq in UNIX shell scripting?
How many types of hash files are there?