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
- 22048 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
What are the enhancements made in datastage 7.5 compare with 7.0?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Distinguish between informatica & datastage. Which one would you choose and why?
What are the areas of application?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the types of views in datastage director?
What is the differentiate between data file and descriptor file?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How do you import and export the datastage jobs?
What are datastage sequences?
How to find value from a column in a dataset?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How to RD using transformer?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
