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
- 22368 Views
- I also Faced
- E-Mail Answers
Answer Posted / amjad pasha
SOURCE ---> SORT STAGE(sort key mode = sort, create cluster
key change column and create key change column should be
false) ---> COPY STAGE ---> (2 REMOVE DUPLICATE STAGES)
REMOVE DUPLICATE STAGE_1 (key=dept and Duplicate to Retain
= First) AND REMOVE DUPLICATE STAGE_2 (key=dept and
Duplicate to Retain = Last) ---> FUNNEL STAGE (Funnel
Type=Continues Funnel) ---> TARGET
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Define ds designer?
Nls stands for what in datastage?
Can you explain tagbatch restructure operator?
What is the difference between Datastage 7.5 and 7.0?
What is a datastage job?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
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
Differentiate between data file and descriptor file?
Describe the main features of datastage?
Where the datastage stored his repository?
how do u catch bad rows from OCI stage? And what CLI stands for?
Is it possible to query a hash file?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Explain the datastage parallel extender (px) or enterprise edition (ee)?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
