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...
- 6 Answers
- 14994 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sireesh
hiii, We can Import data from the Excel sheet If the Excel
ODBC drivers are installed (check the manual in Informatica
7.x). It Would be great to hear from some one regarding
splitting one column into two columns.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How might you approve all mappings in the archive all the while?
draw informatica architecture 8.6 ?
What does role playing dimension mean?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How many ways a relational source definition can be updated and what are they?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain the types of lookup transformation?
What do you mean by blocking transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is informatica worklet?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is deployment group?
What is substr in informatica?
