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 / c raghavendra nivas

Answer Posted / c raghavendra nivas

-------removeduplicate(first)
source---copy ------funnel----output
-------removeduplicate(last)

it works i did it
try if u want

if its a database you can do witha co-related sub query

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you reject records in a transformer?

1105

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2451

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2699

How complex jobs are implemented in datstage to improve performance?

1018

Where do the datastage jobs get stored?

1188

What are the types of views in datastage director?

1755

How can you write parallel routines in datastage PX?

997

What is the purpose of pivot stage and types of containers in datastage

1024

Define Job control?

1118

What is the difference between server job and parallel jobs?

1134

What are routines in datastage?

1308

What is ds designer?

1078

What are the types of containers and how to create them?

958

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3238

1075