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 / disney
first sort the both name and compamy and then,
using stage variable in transformer:
curr= name:company
val=if curr <> prev then 1 else val+1
prev=curr
o.p = val
name,company,val
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Difference between sequential file and data set?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are stage variables?
How to perform incremental load in datastage?
what is repositery?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are some prerequisites for datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are the stages in datastage?
How do you start developing a datastage project?
How to read multiple files using a single datastage job if files have the same metadata?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the differentiate between data file and descriptor file?
What are transforms and what is the differenece between routines and transforms?
Can we use target hash file as a lookup ?