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
- 22147 Views
- I also Faced
- E-Mail Answers
Answer Posted / prabhu
source->sortstage->removeduplications->dataset
in sortstage->create key changecolumn=true
after
removeduplicates stage->duplicates retain:-last
we can get last and first record group wise.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are the job parameters?
how to write server Routine coding?
how to implement scd2 in datastage 7.5 with lookup stage
How many types of hash files are there?
What are the features of datastage flow designer?
Difference between in process and inter process?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How do you import and export the datastage jobs?
What are sequencers?
How a source file is populated?
What are the functionalities of link partitioner?
What a datastage macro?
How do u convert the columns to rows in datastage?
What is a quality stage in datastage tool?
Can you explain engine tier in information server?
