Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / tsyganok.ivan

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

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

How to create a doccument in datastage?

1 Answers   Cap Gemini,

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  

how to convert rows into columns

2 Answers   IBM,

how to get the unique records on multiple columns by using sequential file stage only

3 Answers  

How can we do null handling in sequential files?

3 Answers   Reliance,

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories