Interested to Buy Any Domain ? << Click Here >> for more details...
i/p
1,a,1000
2,b,2000
3,c,3000
i want to get o/p as
o/p
1,a,3000
2,b,4000
3,c,5000
how it can be done on using datastage?
- 5 Answers
- 12834 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / ra
Simple.
ano,aname,amt
1,a,1000
2,b,2000
3,c,3000
column derivation write like this (amt+2000) then we will get o/p
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
Can you explain kafka connector?
What are the main features of datastage?
What is the difference between hashfile and sequential file?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Triggers,VIEW,Procedures
CHANGE CAPTURE
How to convert RGB Value to Hexadecimal values in datastage?
What is orabulk stage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Describe the main features of datastage?
What are some different alternative commands associated with "dsjob"?
Where the datastage stored his repository?
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
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Does datastage support slowly changing dimensions ?
