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...

I've an excel sheet, in which one column contains data about
the location like "City, State" and few columns contains
only "State". Now I wanna load into my target City and State
into two different columns. Pls help me out...

Answer Posted / nagraju bhatraju

We can't import excel sheet directly in to informatica,
instead , we have to save that file in .csv(Comma Separated
Value Formatt) and then we can use or analyze in
informatica environment.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2020


Clarify the utilization of aggregator cache record?

942


Describe the impact of several join conditions and join order in a joiner transformation?

1005


In warehouses how many schemas are there?

1008


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1192


What is a sequence generator transformation?

950


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1994


How will the document be delivered to me?

1016


Repository user profiles

1705


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

912


Can informatica load heterogeneous targets from heterogeneous sources?

1112


Can we change Dynamic to Static or Persistent cache? If so what happens?

2144


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1929


What are the advantages of informatica?

956


lookup transformation with screenshots

3937