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
- 19905 Views
- I also Faced
- E-Mail Answers
Answer Posted / d anil babu
take source--->copy---->remove dupli stage---->
----->remove dupli stgae-->funnel-->dataset
in first remove duplicate stage select duplicate retain first
in second rmd select duplicate retain last and in funnel u
have to select the sort funnel
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is "fatal error/rdbms code 3996" error?
What are the different types of lookups in datastage?
How do you start developing a datastage project?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Name the command line functions to import and export the DS jobs?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Why we use surrogate key?
What is the command line function to import and export the ds jobs?
why do u need the IOS upgradation in a FC switch
Can you explain tagbatch restructure operator?
how to implement scd2 in datastage 7.5 with lookup stage
Can you define merge?
How to perform incremental load in datastage?
describe the Steps to confiure a Qlogic switch
What are the various kinds of containers available in datastage?
