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.
Answer Posted / amjad pasha
SOURCE ---> SORT STAGE(sort key mode = sort, create cluster
key change column and create key change column should be
false) ---> COPY STAGE ---> (2 REMOVE DUPLICATE STAGES)
REMOVE DUPLICATE STAGE_1 (key=dept and Duplicate to Retain
= First) AND REMOVE DUPLICATE STAGE_2 (key=dept and
Duplicate to Retain = Last) ---> FUNNEL STAGE (Funnel
Type=Continues Funnel) ---> TARGET
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Why do we use link partitioner and link collector in datastage?
What are routines in datastage?
Define project in datastage?
What are orabulk and bcp stages?
What are the features of datastage flow designer?
Name the command line functions to import and export the DS jobs?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
what is the use of materialized view?
What is datastage?
Can you explain tagbatch restructure operator?
Explain usage analysis in datastage?
Terminate Activity
How to find value from a column in a dataset?
To see hidden files in LINIX?