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
- 22378 Views
- I also Faced
- E-Mail Answers
Answer Posted / prabhu
source->sortstage->removeduplications->dataset
in sortstage->create key changecolumn=true
after
removeduplicates stage->duplicates retain:-last
we can get last and first record group wise.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
what are the devoleper roles in real time? plz tell i am new to datastage....
How do you start developing a datastage project?
What is the importance of the exception activity in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Differentiate between odbc and drs stage?
Where do you see different stages in the designer?
What are the features of datastage flow designer?
Why do you need stage variables?
How to find value from a column in a dataset?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are transforms and what is the differenece between routines and transforms?
