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
- 20968 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
What are the types of containers and how to create them?
Explain entity, attribute and relationship in datastage?
What is staging variable?
How will you move hashed file from one location to another location?
Lookup constraints
What is the differentiate between data file and descriptor file?
Which warehouse using in your datawarehouse
What is job control?
What is the command line function to import and export the ds jobs?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How do you start developing a datastage project?
What is the importance of the exception activity in datastage?
What are datastage sequences?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Can you explain how could anyone drop the index before loading the data in target in datastage?
