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
- 22138 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 is difference between symmetric multiprocessing and massive parallel processing?
Name the third party tools that can be used in datastage?
What is the difference between operational data stage (ods) and data warehouse?
Explain the importance of surrogate key in data warehousing?
What is usage analysis in datastage?
How to implement complex jobs in data stage?
Can you explain players in datastage?
How to reverse the string using unix?
What is orabulk stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is the difference between account and directory options ?
Highlight the main features of datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How do you import and export data into datastage?
Can you implement SCD2 using join, transformer and funnel stage?
