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 steps needed to create a simple basic datastage job?

664


Define data aggregation?

672


Define repository tables in datastage?

705


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1053


Differentiate between hash file and sequential file?

587






sed,awk,head

971


What are the types of hashed files in data stage

646


What are data elements?

661


What are routines in datastage? Enlist various types of routines.

629


What are orabulk and bcp stages?

651


What could be a data source system?

581


Is it possible to query a hash file?

1567


Difference between data warehousing and olap?

653


Define meta stage?

786


What is "fatal error/rdbms code 3996" error?

663