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
- 20966 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
How do y read Sequential file from job control?
Could anyone give brief explanation bout datastage admin
How many types of stage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the benefits of datastage?
What is the difference between informatica and datastage?
What is merge stage?
What is the difference between orabulk and bcp stages?
What is difference between symmetric multiprocessing and massive parallel processing?
Describe the architecture of datastage?
AGGREGATOR default datatype
What all the types of jobs you developed?
how to export or import the jobs in .ISX file
explain about citrix scheduling tool in datastage
Lookup constraints
