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

Question Posted / tsyganok.ivan

4 Answers
26981 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / santhu

Sorry its not String we shoud use str("0",1)

Is This Answer Correct ?

8 Yes

0 No

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

Answer / ranjan

use the below function to add "0" in transformer

"0" : fieldname

Is This Answer Correct ?

12 Yes

6 No

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

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

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

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

Post New Answer

More Data Stage Interview Questions

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

2 Answers IBM,

What are the features of datastage flow designer?

0 Answers

where the log files or tables can store in DS?

2 Answers IBM,

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

0 Answers Syntel,

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers TCS,

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers CGI,

What are the job parameters?

0 Answers

LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?

2 Answers Mannar Company, ME,

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

0 Answers

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

0 Answers Wipro,

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers

Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 Answers

For more Data Stage Interview Questions Click Here