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
- 12513 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What are the different types of lookups in datastage?
what is main difference between change capture and change apply stages
What is oci?
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
1.what is materialized data? 2.how to view the materialized data?
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
Name the different sorting methods in datastage.
what is advantages of snowflake when it is used?
What is meta stage?
What is the difference between an operational datastage and a data warehouse?
Have you used Unstructured data?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Teradata 
