Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 22050 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
What are stage variables?
Which warehouse using in your datawarehouse
What all the types of jobs you developed?
why do u need the IOS upgradation in a FC switch
How do you import and export data into datastage?
What is a merge in datastage?
in oracle target stage when we use load option and when we use upsert option?
what is the use of surogate key in datastage
What are the functionalities of link collector?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How a server job can be converted to a parallel job?
What is datastage?
What are routines in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Can you explain players in datastage?
