How to add zero "0" before record in a field?
- 4 Answers
- 27308 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 and where you used hash file?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
What are the areas of application?
Describe the architecture of datastage?
where the log files or tables can store in DS?
Two source files contains same meta data third file contains different data types can I funnel that file.
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How do you find the number of rows in a sequential file?
What is "fatal error/rdbms code 3996" error?
Teradata 
