| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: transfer data from xls and ms-access to oracle
Answer: how we can transfer data from ms-excel, ms-access to oracle through informatica ? whether it is possible? |
| May 05, 2008 04:36:36 |
#2 |
| aniban |
Member Since: May 2008 Total Comments: 3 |
RE: transfer data from xls and ms-access to oracle
|
Both are very much possible
w/ INFA: Write a mapping with src as Excel (or Access) and tgt as Oracle. Note: if your Informatica server is on UNIX, you need to save the XLS as csv and use that.
w/o INFA: Using a tool like TOAD can read data from XLS or MS-Access (Data Import Wizard in TOAD)
Cheers,
- AniBan |
| |
Back To Question | |
