Interested to Buy Any Domain ? << Click Here >> for more details...
How to add zero "0" before record in a field?
- 4 Answers
- 26816 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 are data elements?
Can you filter data in hashed file?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
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
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is aggtorec restructure operator?
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
how to change left and right links in join stage?
how to delete one row in target dataset
Is possible to create skid in dim,fact tables?
how to identifie,is it innerjoin,leftouter join in lookup?
How can we improve the performance in datastage?
Teradata 
