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
- 14828 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
Which transformation is needed while using the Cobol sources as source definitions?
how to load dimension table and fact table. plz tell me the steps.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is informatica powercenter repository?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are mapplets? How is it different from a Reusable Transformation?
Have you worked with/created Parameter file
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?
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 types of schemas we have in data warehouse and what are the difference between them?
What is a standalone command task?
What are the limitations of joiner transformation?
In development project what is the process to follow for an etl developer from day1
generate date / time dimension in informatica
What is the difference between router and filter?
