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 types of containers and how to create them?

772


Can you explain engine tier in information server?

887


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1883


What is the difference between datastage and datastage tx?

831


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

3534


Where do the datastage jobs get stored?

975


What are the different layers in the information server architecture?

872


Difference between in process and inter process?

941


What are the features of datastage flow designer?

834


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1170


What is datastage engine?

947


Explain how a source file is populated?

1105


CHANGE CAPTURE

1105


What is a datastage job?

806


How can we improve the performance in datastage?

879