What are Target Types on the Server?

Target types are relational,file and XML

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.

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

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.

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.

Files, Relational, ERP

Relational Database: MS Access,
Flat file: XML, SAP and other external tools.

The target types on the server are flat-file, xml, ERP, Cobol etc

It may be flat file or relational table.