GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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