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.
- 8 Answers
- 20958 Views
- I also Faced
- E-Mail Answers
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
Could anyone give brief explanation bout datastage admin
Explain Quality stage?
What is the purpose of pivot stage?
How to perform incremental load in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are orabulk and bcp stages?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the purpose of interprocessor stage in server jobs?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Is possible to create skid in dim,fact tables?
describe the Steps to confiure a Qlogic switch
Why do you need stage variables?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are datastage sequences?
Differentiate between validated and Compiled in the Datastage?
