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

What are the main issues while working with flat files as source and as targets ?

1096


What is transformation?

1050


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2020


What is native users?

1100


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

998


What is the advantage of informatica?

1013


How do you manage the Parameter files while migrating your data from one environment to another environment?

964


Differentiate between router and filter transformation?

952


What are the measure objects?

1118


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1056


What could be the possible resons of locks by user?

1033


What the difference is between a database, a data warehouse and a data mart?

1080


What are the different clients of powercenter?

1006


What is the status code in stored procedure transformation?

1119


How you can differentiate between connected lookup and unconnected lookup?

1006