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
- 20959 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashok
Source--->Sort stage--->copy stage
From copy stage we have to take two source stages
(source1,source2)
source1-->Removeduplicate stage(in this we can get first
record from each dept)
source2--->Remove duplicate stage(in this we can get last
record from each dept)
using funnel we can add these results.
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
Why do we use link partitioner and link collector in datastage?
How rejected rows are managed in datastage?
What is ibm datastage flow designer?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Can you explain tagbatch restructure operator?
On which Dimension Table you implemented SCD Type in your Project
What are the different layers in the information server architecture?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the importance of the exception activity in datastage?
What are the steps required to kill the job in Datastage?
What are the components of datastage?
Can you highlight the main features of ibm infosphere information server?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the partitioning techniques available in link partitioner?
What is a quality stage in datastage tool?
