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
- 22156 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 should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the enhancements made in datastage 7.5 compare with 7.0?
How many areas for files does datastage have?
State the difference between an operational datastage and a data warehouse?
How many types of stage?
What is the difference between operational data stage (ods) and data warehouse?
What can we do with datastage director?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is the difference between an operational datastage and a data warehouse?
What are the benefits of datastage?
What are the important features of datastage?
What is the difference between account and directory options ?
How do you generate sequence number in datastage?
