| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
| Question: What are Target Types on the Server?
Answer: Target Types are File, Relational and ERP. |
| April 04, 2007 11:45:30 |
#4 |
| manojkumar_dwh |
Member Since: April 2007 Total Comments: 1 |
RE: ... |
PowerCenter can load data into the following targets: - Relational. Oracle, Sybase, Sybase IQ, Informix, IBM DB2, Microsoft SQL Server, and Teradata.
- File. Fixed and delimited flat file and XML.
- Application. You can purchase additional PowerCenter Connect products to load data into SAP BW. You can also load data into IBM MQSeries message queues and TIBCO.
- Other. Microsoft Access.
You can load data into targets using ODBC or native drivers, FTP, or external loaders. |
| |
Back To Question | |