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 / abhishek
hey friend
as i know we can not import excel sheet in informatica.
your qustion is this or something else?please elaborate
this
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
How many transformations can be used in mapplets.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain what are the different versions of informatica?
server hot-ws270 is connect to Repository B. What does it mean?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How do you use reject loader.
Global and Local shortcuts. Advantages.
Explain about Informatica server process that how it works relates to mapping variables?
Is it possible to use a client with different version than that of its Informatica server?
What is parallel processing in informatica?
What is enterprise data warehousing?
Define joiner transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is mapping debugger?