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

Why filter transformation is an active one?

941


During the running session, output files are created by informatica server. Enlist few of them.

944


What is meant by lookup transformation?

1046


Explain what transformation and how many are there in informatica?

899


generate date / time dimension in informatica

1077


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2091


Define the various join types of joiner transformation?

953


How big was your fact table

1756


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1063


How can we use mapping variables in informatica? Where do we use them?

1117


What are the measure objects?

1129


Parameter and variable differences

2020


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1027


Define filter transformation?

1038


Explain the aggregator transformation?

1102