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


Please Help Members By Posting Answers For Below Questions

How to find value from a column in a dataset?

1769


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1808


what is repositery?

1297


Can you explain tagbatch restructure operator?

705


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1721






Define meta stage?

786


Triggers,VIEW,Procedures

802


What is the difference between operational data stage (ods) and data warehouse?

675


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2053


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2276


What are the different kinds of views available in a datastage director?

606


What is a folder? Difference types of stages?

632


in oracle target stage when we use load option and when we use upsert option?

1754


Define Merge?

879


How to implement complex jobs in data stage?

618