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
- 22051 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
CHANGE CAPTURE
What is meta stage?
What is use Array size in datastage
Which algorithm you used for your hashfile?
Define orabulk and bcp stages?
How do you remove duplicate values in datastage?
How can we improve the performance in datastage?
What are the processing stages?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what is flow of project?
Differentiate between Join, Merge and Lookup stage?
What is the difference between an operational datastage and a data warehouse?
What are the important features of datastage?
How one source columns or rows to be loaded in to two different tables?
Have you have ever worked in unix environment and why it is useful in datastage?
