I have a input as:
Col
1
1
2
2
3
I want 3 output as:
Output1:
1
1
Output2:
2
2
Output3:
3
i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
Answer Posted / suneelbabu.etl
can u mention some more input records as well output
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Give an idea of system variables.
How do y read Sequential file from job control?
What are the types of containers 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
What is the importance of the exception activity in datastage?
what is repositery?
How a server job can be converted to a parallel job?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
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.
How and where you used hash file?
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.
Define ds designer?
What are the functionalities of link partitioner and link collector?
How to manage date conversion in Datastage?
What is a merge?