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 can you load data into target table without leading zeor's

Answer Posted / srini

By using the Trim function we can able to Remove the
leading Zero's in a value and we can load it in to target.
Function : trim(Col_Nm,'0',L)

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any way to read the ms excel datas directly into informatica?

1022


Write the program through which the records can be updated?

1006


Implementation methodology

1714


How do you set a varible in incremental aggregation

1891


4 yrs etl devloper roles and responsibilities?any body give solutions

2169


what are the deliverables?in your project?

2152


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

977


Whats the difference between informatica powercenter server, repositoryserver and repository?

1175


How union transformation is used?

1006


What is aggregate cache in aggregator transformation?

1145


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2107


How to do unit testing in informatica?

1173


The question was on time stamp. what is the difference between HH and HH24 when to use when.

2057


What is a shortcut and copy in Informatica and how two are different with each other?

1198


Is it possible to revert a global repository to local one and why?

1081