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
- 22140 Views
- I also Faced
- E-Mail Answers
Answer Posted / c raghavendra nivas
-------removeduplicate(first)
source---copy ------funnel----output
-------removeduplicate(last)
it works i did it
try if u want
if its a database you can do witha co-related sub query
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between validated and Compiled in the Datastage?
What is the difference between Datastage 7.5 and 7.0?
Name the different types of Lookups in Datastage?
Demonstrate experience in maintaining quality process standards?
client know skid info?
What is the difference between the local container and shared container?
Differentiate between datastage and informatica?
How do you generate sequence number in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are transforms and what is the differenece between routines and transforms?
What is the use of hoursfromtime() function in transformer stage in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
What is a ds designer?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How to find value from a column in a dataset?
