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?
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 ? | 16 Yes | 1 No |
Post New Answer View All Answers
What is size of a transaction and an array means in a datastage?
Why do we use exception activity in Datastage?
How to read the length of word in unix?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is the difference between hashfile and sequential file?
What are data elements?
To see hidden files in LINIX?
Differentiate between Join, Merge and Lookup stage?
How a server job can be converted to a parallel job?
How many types of sorting methods are available in datastage?
what is the use of materialized view?
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 is the difference between orabulk and bcp stages?
describe the Steps to confiure a Qlogic switch
What is the difference between Datastage 7.5 and 7.0?