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.
Answer Posted / c raghavendra nivas
-------removeduplicate(first)
source---copy ------funnel----output
-------removeduplicate(last)
it works i did it
try if u want
if its a database you can do witha co-related sub query
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the types of containers and how to create them?
How do you schedule or monitoring the job?
What are the types of views in datastage director?
Highlight the main features of datastage?
Define oconv () and iconv () functions in datastage?
Name the third party tools that can be used in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Why we use surrogate key?
What are the components of datastage?
Could anyone give brief explanation bout datastage admin
How to find value from a column in a dataset?
What are routines in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?