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
How one source columns or rows to be loaded in to two different tables?
Can you explain tagbatch restructure operator?
client know skid info?
How do you run datastage job from the command line?
What are the different type of jobs in datastage?
What is a quality stage in datastage tool?
How do y read Sequential file from job control?
what are the errors,warnings in datastage
How to manage date conversion in Datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the benefits of datastage?
What is the difference between server job and parallel jobs?
Notification Activity
What are the features of datastage flow designer?
What is quality stage?