Interested to Buy Any Domain ? << Click Here >> for more details...
How to add zero "0" before record in a field?
- 4 Answers
- 26770 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 |
How to convert table data into xml file using xml output stage? please explain step by step;
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
why do we need a datawarehouse when we have databases to store data?
what is ds administrator used for?
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
table actions available in oracle connector?
Explain how a source file is populated?
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
How a source file is populated?
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
Why we use surrogate key?
Teradata 
