How to add zero "0" before record in a field?
- 4 Answers
- 25009 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 |
Define project in datastage?
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
What is the difference between Link collector and Funnel Stages?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How many nodes supported by a one cpu in parallel jobs?
What are the partition techniques available in your last project?
What are the differences between datastage and informatica?
What's the Main Function of the Staging area in DWH
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
how to remove duplicates in transformer stage by using stage variables?one example?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
sed,awk,head
Teradata 
