GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica
Next Question 
 Informatica  |  Question 1 of 644    Print  

What are Target Types on the Server?

Target Types are File, Relational and ERP.




  
Total Answers and Comments: 6 Last Update: July 27, 2009   
  
 Sponsored Links

 
 Best Rated Answer
Submitted 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.



Above answer was rated as good by the following members:
profile, ravi8485
January 25, 2006 18:17:54   #1  
guest        

RE: ...
Target types are relational file and XML
 
Is this answer useful? Yes | No
November 25, 2006 11:14:00   #2  
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   #3  
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   #4  
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 | NoAnswer is useful 2   Answer is not useful 0Overall Rating: +2    
April 21, 2009 13:09:33   #5  
ASHOK1324 Member Since: April 2009   Contribution: 36    

RE: What are Target Types on the Server?
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.

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
July 27, 2009 11:09:42   #6  
sghatti Member Since: July 2009   Contribution: 1    

RE: What are Target Types on the Server?
Files Relational ERP
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape