Answer Posted / nagaraju bhatraju
Target Types are File, Relational and ERP. Latest Answer :
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 ...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to convert multiple rows to single row (multiple columns) in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How are indexes created after completing the load process?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
generate date / time dimension in informatica
Design time, run time. If you don't create parameter what will happen
What are the different types of transformation available in informatica.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is event and what are the tasks related to it?
What are mapplets?
How can we use mapping variables in informatica?
Explain the aggregator transformation?