Informatica - What are Target Types on the Server?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Informatica | Question 1 of 631

What are Target Types on the Server?

Target Types are File, Relational and ERP.

Total Answers and Comments: 4

Last Update: April 14, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 25, 2006 18:17:54

guest

RE: ...

Target types are relational,file and XML

Is this answer useful? Yes | No

November 25, 2006 11:14:00

kiran kumar

RE: ...

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.

Is this answer useful? Yes | No

November 28, 2006 15:19:35

Pushpam Vaidya

RE: ...

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

Is this answer useful? Yes | No

April 14, 2007 11:45:30

manojkumar_dwh

Member Since: April 2007 Contribution: 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.

Is this answer useful? Yes | No