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?
- 3 Answers
- 22478 Views
- Accenture, I also Faced
- E-Mail Answers
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 will you move hashed file from one location to another location?
What are datastage sequences?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the various kinds of the hash file?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is oci?
How you Implemented SCD Type 1 & Type 2 in your project?
Can you highlight the main features of ibm infosphere information server?
What is the purpose of pivot stage?
How many types of stage?
How can you write parallel routines in datastage PX?
What are the functionalities of link collector?
How to reverse the string using SQL?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
how do u catch bad rows from OCI stage? And what CLI stands for?
