take source--->copy---->remove dupli stage---->

I have a scenario like
Deptno=10---->First record and last record
Deptno=20---->First record and last record
Deptno=30---->First record and last record
I want those first and last records from each department in
a single target. How to do this in DataStage, any one can
assist me.
Thanks in advance.

Question Posted / d anil babu

8 Answers
22146 Views
I also Faced
E-Mail Answers

Answer Posted / d anil babu

take source--->copy---->remove dupli stage---->
----->remove dupli stgae-->funnel-->dataset
in first remove duplicate stage select duplicate retain first
in second rmd select duplicate retain last and in funnel u
have to select the sort funnel

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a merge?

1171

Can you explain kafka connector?

1312

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2814

Define project in datastage?

1100

Describe link sort?

1018

What is staging variable?

1099

what is the use of surogate key in datastage

2310

Lookup constraints

1263

What is the difference between datastage and informatica?

1120

How to find value from a column in a dataset?

2203

What is orabulk stage?

1047

How you Implemented SCD Type 1 & Type 2 in your project?

4129

Define Routines and their types?

1188

Where do the datastage jobs get stored?

1218

describe the Steps to confiure a Qlogic switch

2383