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 / 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
Describe stream connector?
Explain usage analysis in datastage?
options available in sequence job to run,validate?
Explain the importance of surrogate key in data warehousing?
What is job control?
Explain connectivity between datastage with datasources?
What is data partitioning?
What are the functionalities of link partitioner?
How rejected rows are managed in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
project Steps,hits, Project level HArd things,Solved methods?
Why we use surrogate key?
Differentiate between validated and Compiled in the Datastage?
What all the types of jobs you developed?