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 ?    16 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

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers   Bank Of America, IBM,

How many types of sorting methods are available in datastage?

0 Answers  

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers   HCL,

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,




I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

Explain the ChangeApply stage?

11 Answers  

How to create a doccument in datastage?

1 Answers   Cap Gemini,

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

For more Data Stage Interview Questions Click Here
Categories