Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 21866 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
How do you import and export data into datastage?
what is use of SDR function?
What are the types of jobs we have in datastage?
What is the different type of jobs in datastage?
What are the partitioning techniques available in link partitioner?
How rejected rows are managed in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the difference between passive stage and active stage?
What are the areas of application?
project Steps,hits, Project level HArd things,Solved methods?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
how to abort the job its matain duplicates?
What are the benefits of datastage?
How many Key we can define in remove duplicate stage?
What is the process of killing a job in datastage?
