for 2nd Qn: Source is: Col1 Col2 1 10 2 10 3 10 In transfo

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?

Question Posted / subhash

3 Answers
23755 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

Please Help Members By Posting Answers For Below Questions

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2295

Explain ibm infosphere information server and highlight its main features?

1095

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1557

What are the components of datastage?

1127

How rejected rows are managed in datastage?

1527

How to manage date conversion in Datastage?

1144

Can you define merge?

1137

What are the repository tables in datastage?

1311

what is the custome stage in datastage? how can we impliment that one? plz tell me

2371

Can you explain repository tables in datastage?

1414

What are the job parameters?

1226

How to read multiple files using a single datastage job if files have the same metadata?

1255

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1422

Does datastage support slowly changing dimensions ?

1110