ETL (Extract, transform, load) Question: Download Questions PDF
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?
![Extract, transform, load (ETL) Interview Answer Extract, transform, load (ETL) Interview Question](https://globalguideline.com/public/images/interview/15.png)
Answer:
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 .
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 .
Download Extract, transform, load (ETL) Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain What is the metadata extension? | Explain What are snapshots? What are materialized views & where do we use them? What is a materialized view log? |