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
- 22375 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
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the steps required to kill the job in Datastage?
What are the benefits of datastage?
What is difference between join, merge and lookup stage?
What are the repository tables in datastage?
Define meta stage?
how to abort the job its matain duplicates?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Define Job control?
What is the sortmerge collector?
Could anyone give brief explanation bout datastage admin
Different ways a project can be moved to production ?...example ….export-import and Version control.
How to read multiple files using a single datastage job if files have the same metadata?
Can you explain repository tables in datastage?
What is the flow of loading data into fact & dimensional tables?
