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
- 22042 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 can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Define oconv () and iconv () functions in datastage?
table actions available in oracle connector?
What is use Array size in datastage
Differentiate between odbc and drs stage?
How do you reject records in a transformer?
How to implement complex jobs in data stage?
How many Key we can define in remove duplicate stage?
How do you import and export the datastage jobs?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
in oracle target stage when we use load option and when we use upsert option?
What is the difference between operational data stage (ods) and data warehouse?
What is the purpose of pivot stage and types of containers in datastage
Can you explain link buffering?
