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
- 22374 Views
- I also Faced
- E-Mail Answers
Answer Posted / naga
take sequential file and give its output to copy and copy
it to two datasets.in one dataset select the partition on
deptno type=modulus and perform sort and select both stable
and unique you will get first redcords and in another
dataset select partition on deptno and type modulus and
perform sort and select only unique and give give both
dataset outputs to funnel and give its output to dataset
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How to perform incremental load in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
table actions available in oracle connector?
What is the difference between odbc and drs stage?
How do you start developing a datastage project?
What are the different types of lookups in datastage?
What are the some differences between 7.x and 8.x version of datastage?
Difference between data warehousing and olap?
what is flow of project?
Difference between sequential file and data set?
What are the different kinds of views available in a datastage director?
Name the different sorting methods in datastage.
how to abort the job its matain duplicates?
how to add a new records into source?
What are the steps required to kill the job in Datastage?
