⟩ 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?
we cant 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 inforematica open the folder using sources ->import from database->select excel odbc driver->connect->select the excel sheet name .