How to add zero "0" before record in a field?
- 4 Answers
- 25940 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 is datastage engine?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
How you Implemented SCD Type 1 & Type 2 in your project?
How many jobs in ur project? Explain any complex job u have done in ur project?
how to define satge variables in transformer stage
Differentiate between validated and Compiled in the Datastage?
Hi This is Vijay, How can your remove the duplicates in sequential File?
15 Answers HCL, Scope International,
I have a few records all are same structures data, I want to store data in multiple targets how?
what is executable in DataStage?
what is advantages of snowflake when it is used?
Teradata 
