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
- 22139 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
Where do you see different stages in the designer?
How to perform incremental load in datastage?
table actions available in oracle connector?
How complex jobs are implemented in datstage to improve performance?
What are the different kinds of views available in a datastage director?
How do you schedule or monitoring the job?
What are stage variables?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the command line function to import and export the ds jobs?
What is size of a transaction and an array means in a datastage?
What are the different type of jobs in datastage?
Is it possible to query a hash file?
What is datastage engine?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How the ipc stage work?
