1.

Is There Any Way To Read The Ms Excel Data's Directly Into Informatica? Like Is There Any Possibilities To Take Excel File As Target?

Answer»

we can’t directly import the xml file in informatica.
we have to define the MICROSOFT EXCEL odbc driver on our system and define the name in exce sheet by defining ranges then in informatica open the folder using SOURCES ->import from DATABASE->SELECT excel odbc driver->connect->select the excel sheet name .

we can’t directly import the xml file in informatica.
we have to define the Microsoft excel odbc driver on our system and define the name in exce sheet by defining ranges then in informatica open the folder using sources ->import from database->select excel odbc driver->connect->select the excel sheet name .


Discussion

No Comment Found

Related InterviewSolutions