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
- 22377 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashok
Source--->Sort stage--->copy stage
From copy stage we have to take two source stages
(source1,source2)
source1-->Removeduplicate stage(in this we can get first
record from each dept)
source2--->Remove duplicate stage(in this we can get last
record from each dept)
using funnel we can add these results.
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How you Implemented SCD Type 1 & Type 2 in your project?
Which warehouse using in your datawarehouse
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the difference between orabulk and bcp stages?
What are sequencers?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is active and passive stage?
How to read the length of word in unix?
What is the difference between account and directory options ?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the partitioning techniques available in link partitioner?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Can you highlight the main features of ibm infosphere information server?
