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

What is primary and backup node?

1128


In development project what is the process to follow for an etl developer from day1

1724


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1268


How to elaborate powercenter integration service?

1136


explain one complex mapping with logic? sales project?

6670


Define update strategy?

1230


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1294


Please let me know how to make encryption and decryption with example?

1900


What are the differences between a connected lookup and unconnected lookup?

1070


Can u generate reports in Informatica?

1089


How can we improve session performance in aggregator transformation?

1117


What do you mean by enterprise data warehousing?

1065


wat are deployement groups in informatica, how it will be used for developers

1719


What do you understand by SOA of Informatica?

992


What is the benefit of session partitioning?

1116