Answer Detail: RE: transfer data from xls and ms-access to oracle

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 11:31:31	#1
vivek1708	Member Since: May 2008 Total Comments: 18
RE: transfer data from xls and ms-access to oracle
Ya this is possible. For higher versions of oracle 10g onwards this can be done in 2 ways 1) without using informatica --MS excel - This can be directly imported into oracle --MS access - Using Migration workbench - another free tool provided by oracle. 2) using informatica - --using source as excel file and target as oracle table.

Back To Question