how can i get 2nd highest salary in datastage?can u send me
,thanQ
2)if i had source has 2 records 1st record ie 1st column
contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to
get target as 2nd columns as 20,30,40 how can i?
Answer Posted / subhash
for 2nd Qn:
Source is:
Col1 Col2
1 10
2 10
3 10
In transformer, we put the below logic:
Link.Col1 * Link.Col2 + Link.Col2------>Col2
1*10+10------------->20
2*10+10------------->30
3*10+10------------->40
Hope this is fine.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Different ways a project can be moved to production ?...example ….export-import and Version control.
Does datastage support slowly changing dimensions ?
What are the types of hashed files in data stage
Differentiate between data file and descriptor file?
What are the types of views in datastage director?
What are some prerequisites for datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
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
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How will you move hashed file from one location to another location?
What are routines in datastage? Enlist various types of routines.
What are the types of containers?
What is the sortmerge collector?
What is the difference between the local container and shared container?
Is it possible to query a hash file?