How to add zero "0" before record in a field?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the main features of datastage?

960


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1870


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1711


What is the difference between in process and inter process?

936


What are orabulk and bcp stages?

917


how many rows sorted in sort stage by default in server jobs

3788


Whats difference betweeen operational data stage (ods) and data warehouse?

930


What is the difference between Datastage 7.5 and 7.0?

911


What are the types of hashed files in data stage

901


how can we create rank using datastage?what is the meaning of rank?

8488


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3069


What is the use of datastage director?

827


What is the difference between server job and parallel jobs?

946


i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3549


What are the different type of jobs in datastage?

876