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 / saran
in TFM stage we are mapping i/p records to o/p
then i/p metadata appear in o/p link then go to required column o/p link write there derivation whatever we want
in TFM stage
ex--- ano,aname,amt
1,a,3000
2,b,4000
3,c,5000
column derivation write like this (amt+1000)
Is This Answer Correct ? | 1 Yes | 12 No |
Post New Answer View All Answers
Describe link sort?
Differentiate between data file and descriptor file?
What is the flow of loading data into fact & dimensional tables?
What are datastage sequences?
How do y read Sequential file from job control?
how can we create rank using datastage?what is the meaning of rank?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are stage variables?
What is ds designer?
What is the sortmerge collector?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is datastage?
What is the roundrobin collector?
What is the difference between in process and inter process?