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...

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between symmetric multiprocessing and massive parallel processing?

1200


What is the use of datastage director?

1073


Why do you need stage variables?

1231


Which algorithm you used for your hashfile?

1234


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4098


What are the steps required to kill the job in Datastage?

1269


What is oci?

1356


How to read the length of word in unix?

1434


Explain Quality stage?

1210


Which commands are used to import and export the datastage jobs?

1462


in oracle target stage when we use load option and when we use upsert option?

2323


What is job control?

1200


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

3020


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

980


What are the different common services in datastage?

1337