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
What are mapplets?
what are 3 tech challenges/ common issues you face?
Is there any way to read the ms excel datas directly into informatica?
How is union transformation utilized?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain informatica architecture - version 8 / 9
How to generate sequence numbers without using the sequence generator transformation?
What is informatica? Why do we need it?
Explain about Informatica server process that how it works relates to mapping variables?
Define mapplet?
How will the document be delivered to me?
How to elaborate powercenter integration service?
What is workflow monitor?
Is it possible to define a single node as a Gateway node as well as worker node?
Can we get 1st record through Informatica(without sequence number).