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
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the different types of transformation available in informatica.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are batches?
What are connected or unconnected transformations?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Differentiate between a database and data warehouse?
What is lookup change?
explain abt ur project architecture?
What is the cumulative sum and moving sum?
Did u used latest transformations of 8.6.0? for what?
What is persistent lookup cache?