1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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?

Question Posted / karthikmareedu

Answers were Sorted based on User's Feedback



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,..

Answer / 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

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,..

Answer / hussy

Hi,

My suggestion is instead of calculating for each column.

Create a stage variable (amt+2000)----> STG1

Call this STG1 in your derivation output amount column.

Is This Answer Correct ?    7 Yes 0 No

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,..

Answer / karthi

how can u do this in tfm explain

Is This Answer Correct ?    1 Yes 4 No

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,..

Answer / 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

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,..

Answer / saran

using TFM stage we can get o/p like this
in TFM stage write derivation on column level
i.e link.column+1000

Is This Answer Correct ?    0 Yes 13 No

Post New Answer

More Data Stage Interview Questions

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

In merge stage can we update the values?

3 Answers   TCS,

What is the version control how can i apply this in DataStage can any one tell me the anser

4 Answers   IBM,

how CAN we remove duplicates in dataset?

2 Answers   IBM,




I have 100 records how can I load at a time from the single time

1 Answers  

What are the types of containers and how to create them?

0 Answers  

how to validate the jobs

2 Answers   IBM,

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

1 Answers   Infosys,

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

For more Data Stage Interview Questions Click Here
Categories