How to add zero "0" before record in a field?
- 4 Answers
- 24977 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ranjan
use the below function to add "0" in transformer
"0" : fieldname
| Is This Answer Correct ? | 12 Yes | 6 No |
Answer / santhu
Ranjan is right but when we want add 4 zeros("0")then By Using String Function we can do that
String("o",1):Column name
Here 1 is how many zeros we want
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / dhanasekar
Str(%string%,%repeats%) is the function used in transformer to repeat a string for a number of times we required.
%String%-> represents the string we want to repeat
%repeats%->its a no represents how many times the string to be repeated.
Example: Str("0",1):Column_name
| Is This Answer Correct ? | 3 Yes | 3 No |
what is the use of invokation id
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?
6 Answers CTS, HCL, IBM, Wipro,
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
How to convert alpha Numeric values to alpha using functions?
On which interface you will be working as a developer?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
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.
Hai..,in datastage how to explain project in interview?please explain any domain please.
Teradata 
