What are Target Types on the Server?

Target Types are File, Relational and ERP.

Editorial / Best Answer

manojkumar_dwh  

  • Member Since Apr-2007 | Apr 14th, 2007


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.

Showing Answers 1 - 25 of 25 Answers

guest

  • Jan 25th, 2006
 

Target types are relational,file and XML

  Was this answer useful?  Yes

kiran kumar

  • Nov 25th, 2006
 

hai friend

 Targets on server or file,Relation and ERP.

FILE: FTPfiles

Relation: insert,delete,update,update as update,update else insert.update as update, truncate

there r no targets for ERP.

  Was this answer useful?  Yes

Pushpam Vaidya

  • Nov 28th, 2006
 

Target types are:File, RDBMS, FTP , XML , Queues( MQ Series, Java Queues these are type of targets for Real time data movement)

  Was this answer useful?  Yes

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.

ASHOK1324

  • Apr 21st, 2009
 

Informatica Power Center Server can load the data into below target systems:

Standard: RDBMS, Flat Files, XML, ODBC

Applications: SAP R/3, SAP BW, PeopleSoft, Siebel, JD Edwards, i2

EAI: MQ Series, Tibco, JMS, Web Services

Legacy: Mainframes (DB2)AS400 (DB2)

Different types of RDMBS include Oracle, SQL Server, MySQL, IBM DB2, Sybase, Informix, Teradata etc.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions