Interested to Buy Any Domain ? << Click Here >> for more details...
How to add zero "0" before record in a field?
- 4 Answers
- 27017 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 read multiple files using a single datastage job if files have the same metadata?
Explain ibm infosphere information server and highlight its main features?
How many Nodes configuration file you used in your last project?
How can remove duplicates in a file using UNIX?
How did you reconcile source with target?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
I have a few records just I want to store data in to targets cycling way how?
in oracle target stage when we use load option and when we use upsert option?
How we can covert server job to a parallel job?
how to cleansing data
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
Teradata 
