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 / abhinaw prakash

We can use Replace function as well to remove the zeroes
before loading the data into the target

Is This Answer Correct ?    0 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we store previous session logs?

1001


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7126


How does a rank transform differ from aggregator transform functions max and min?

1155


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

1093


Enlist the advantages of informatica.

1014


Explain the features of connected and unconnected lookup.

889


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

1073


Differentiate between a repository server and a powerhouse?

1058


explan ur project architecture?

2014


r u done any partitions in ur project?

1762


What is an unconnected transformation?

1040


can we override a native sql query within informatica? How do we do it?

1064


What is data transformation manager process?

1090


What is the procedure for creating independent data marts from informatica 7.1?

1015


What is meant by query override?

1013