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 override a native sql query within informatica? How do we do it?

1186


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

1159


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1200


What is meant by active and passive transformation?

1191


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2249


What are the conditions needed to improve the performance of informatica aggregator transformation?

1139


What is different between the data warehouse and data mart?

1112


State the differences between sql override and lookup override?

1283


If informatica has its scheduler why using third party scheduler?

1306


4 yrs etl devloper roles and responsibilities?any body give solutions

2245


How union transformation is used?

1057


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2081


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2577


What is a repository? And how to add it in an informatica client?

1192


When do you use sql override in a lookup transformation?

1140