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
- 21855 Views
- I also Faced
- E-Mail Answers
Answer Posted / naga
take a sequential file and give the output link to copy
stage and from copy stage give one output link to head
stage and one output to tail stage and in head and tail
stages give no. of partitions per record =1 and give the
output to funnel stage and give funnel type = sequence and
mention the link order to displays which records first and
give the output link to dataset and you will get the output
you want
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
sed,awk,head
Define repository tables in datastage?
What are the different layers in the information server architecture?
Distinguish between informatica & datastage. Which one would you choose and why?
what is the use of skid in reporting?
what is repositery?
Define Routines and their types?
Where the datastage stored his repository?
How and where you used hash file?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is the difference between datastage and datastage tx?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
explain about citrix scheduling tool in datastage
What is the purpose of interprocessor stage in server jobs?
Can we use target hash file as a lookup ?
