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
- 22367 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 is difference between server jobs & parallel jobs?
What is a merge?
What are constraints and derivations?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the difference between operational data stage (ods) and data warehouse?
AGGREGATOR default datatype
What are the various kinds of the hash file?
What is the difference between orabulk and bcp stages?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the difference between in process and inter process?
What is the difference between Datastage 7.5 and 7.0?
Explain datastage architecture?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is size of a transaction and an array means in a datastage?
Where do you see different stages in the designer?
