Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 23621 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
Differentiate between validated and Compiled in the Datastage?
How can we improve performance of data stage jobs?
How the ipc stage work?
What are stage variables, derivations and constants?
Lookup constraints
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
Difference between in process and inter process?
What is the flow of loading data into fact & dimensional tables?
What are the features of datastage flow designer?
What are the stages in datastage?
What is a quality stage in datastage tool?
What are the main features of datastage?
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?
How to find value from a column in a dataset?
Explain usage analysis in datastage?
