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 / sai

Use Exp transformation and use function
Ltrim(col_name,'0')

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different kinds of facts.

1023


What is a connected transformation?

1185


Enlist the tasks for which source qualifier transformation is used.

1075


Explain scd type 3 through mapping.

1055


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

2153


What is the procedure for creating independent data marts from informatica 7.1?

1120


As union transformation gives UNION ALL output, how you will get the UNION output?

1159


What is a difference between complete, stop and abort?

1126


What is an expression transformation in informatica?

1092


What is the function of look up transformation?

1177


How to extract sap data using informatica? What is abap? What are idocs?

1253


What is Cognos script editor?

4290


what are 3 tech challenges/ common issues you face?

2397


Can we create a Integration service without a Repository service and vice versa?

1260


How do you handle two sessions in Informatica

1219