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

trim(Col_Nm,'0',L)

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create multiple integration service on single repository?

1132


What are the components of the workflow manager?

1078


if we have a delimiters at unwanted places in a flat file how can we over come those.

1985


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9969


What do you mean by enterprise data warehousing?

1002


Enlist the tasks for which source qualifier transformation is used.

980


What are the advantages of informatica?

956


I have a flat file, want to reverse the contents of the flat file

1064


Can we change Dynamic to Static or Persistent cache? If so what happens?

2146


Target increases every day even though no new record was inserted

1513


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1219


What are the components of Informatica? And what is the purpose of each?

980


explain about unit testing? in real time?

2133


Describe expression transformation?

1044


Difference between Data and Index Caches?

1090