GeekInterview.com
Series: Subject: Topic:
Question: 725 of 725

What are Target Types on the Server?

Target Types are File, Relational and ERP.

Asked by: Interview Candidate | Asked on: Sep 20th, 2004

Editorial / Best Answer

Answered by: manojkumar_dwh

View all answers by manojkumar_dwh

Member Since Apr-2007 | Answered On : 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 - 9 of 9 Answers
guest

Answered On : Jan 25th, 2006

Target types are relational,file and XML

  
Login to rate this answer.
kiran kumar

Answered On : 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.

  
Login to rate this answer.
Pushpam Vaidya

Answered On : 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)

  
Login to rate this answer.
manojkumar_dwh

Answered On : Apr 14th, 2007

View all answers by manojkumar_dwh

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.

Yes  7 Users have rated as useful.
  
Login to rate this answer.
ASHOK1324

Answered On : Apr 21st, 2009

View all answers by ASHOK1324

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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
sghatti

Answered On : Jul 27th, 2009

View all answers by sghatti

Files, Relational, ERP

  
Login to rate this answer.
svivekananda

Answered On : Jun 26th, 2010

View all answers by svivekananda

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

  
Login to rate this answer.
jayapraveen

Answered On : Oct 3rd, 2010

View all answers by jayapraveen

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

  
Login to rate this answer.
saithirumal

Answered On : Mar 25th, 2011

View all answers by saithirumal

It may be flat file or relational table.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.