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
- 22047 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 and where you used hash file?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
If you want to use a same piece of code in different jobs, how will you achieve this?
How to RD using transformer?
why do u need the IOS upgradation in a FC switch
What is the sortmerge collector?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the main features of datastage?
What are the differences between datastage and informatica?
What are the functionalities of link partitioner and link collector?
What is a quality stage in datastage tool?
Can you implement SCD2 using join, transformer and funnel stage?
How many types of views are there in a datastage director?
How many Key we can define in remove duplicate stage?
What all are the different way to run a job?
