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
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Clarify the utilization of aggregator cache record?
Describe the impact of several join conditions and join order in a joiner transformation?
In warehouses how many schemas are there?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is a sequence generator transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How will the document be delivered to me?
Repository user profiles
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?
Can informatica load heterogeneous targets from heterogeneous sources?
Can we change Dynamic to Static or Persistent cache? If so what happens?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the advantages of informatica?
lookup transformation with screenshots