From source copy the data into sets using copy or peak stage then for eac

i have source like
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100

i want target like

target1
deptno,sal
1,2000
3,4000
4,5000

target2
2,3000
1,2300
5,1100

with out using transformerstage

Question Posted / thippareddy.p

6 Answers
9957 Views
I also Faced
E-Mail Answers

Answer Posted / thippareddy.p

From source copy the data into sets using copy or peak
stage then for each copy stage use remove duplicate stage
with duplicate to retain first and last you will get
desired output.....
Hope thios will help u.......

Is This Answer Correct ?

1 Yes

16 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different type of jobs in datastage?

1000

how to write server Routine coding?

2059

Difference between sequential file and data set?

1133

What is datastage engine?

1118

Can you explain link buffering?

1104

Why we use surrogate key?

1157

Which warehouse using in your datawarehouse

2115

Describe the main features of datastage?

1035

How a server job can be converted to a parallel job?

1041

Define Merge?

1256

Explain Quality stage?

1087

Terminate Activity

1230

How to Remove Duplicate using SQL?

1289

What are the types of containers?

1140

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?

2163