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
- 21867 Views
- I also Faced
- E-Mail Answers
Answer Posted / d anil babu
take source--->copy---->remove dupli stage---->
----->remove dupli stgae-->funnel-->dataset
in first remove duplicate stage select duplicate retain first
in second rmd select duplicate retain last and in funnel u
have to select the sort funnel
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to implement complex jobs in data stage?
Name the command line functions to import and export the DS jobs?
describe the Steps to confiure a Qlogic switch
Name the different types of Lookups in Datastage?
What is the difference between operational data stage (ods) and data warehouse?
How do you run datastage job from the command line?
What could be a data source system?
How do you import and export data into datastage?
What are the primary usages of datastage tool?
What a datastage macro?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
If you want to use the same piece of code in different jobs, how will you achieve it?
Can you explain repository tables in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
In Datastage, how you can fix the truncated data error?
