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?
Submitted by: Administratorwe 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 .
Submitted by: Administrator
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 .
Submitted by: Administrator
Read Online ETL (Extract, transform, load) Job Interview Questions And Answers
Top ETL (Extract, transform, load) Questions
☺ | Explain What is ETL process ?How many steps ETL contains explain with example? |
☺ | How to calculate fact table granularity? |
☺ | Explain What is Full load & Incremental or Refresh load? |
☺ | Explain the difference between etl tool and olap tools? |
☺ | Explain What are the different versions of Informatica? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |