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
- 21032 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 will you move hashed file from one location to another location?
Does datastage support slowly changing dimensions ?
Demonstrate experience in maintaining quality process standards?
How to manage date conversion in Datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
EXPLAIN SCD
what is the use of surogate key in datastage
What is the flow of loading data into fact & dimensional tables?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
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
What is job control?
What are the main features of datastage?
How to reverse the string using unix?
What are constraints and derivations?
