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

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

What are the third party tools you used in your project?

1 Answers   IBM,

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

what is the difference between datasatge and datastage TX?

6 Answers  

how to validate the jobs

2 Answers   IBM,

Difference between sequential file and data set?

0 Answers  

what is data mapping

2 Answers  

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  

i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?

2 Answers  

For more Data Stage Interview Questions Click Here
Categories