Interested to Buy Any Domain ? << Click Here >> for more details...
How to add zero "0" before record in a field?
- 4 Answers
- 27178 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 |
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
how to unlock a locked job in datastage 8.0
What is meta stage?
what is the diff b/w switch and filter stage in datastage
How to convert alpha Numeric values to alpha using functions?
Can we use target hash file as a lookup ?
what is a force compile
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
Is it possible to query a hash file?
Wat is isolation level and when do u use them?
What are the types of jobs we have in datastage?
Teradata 
