Informatica Powercenter

Domain

Node

Service Manager

Application Services

Source

Target

Parameter file

Transformations

Mappings

Mapplets

Session

Tasks

Workflow Manager

Workflow Monitor

Performance Tuning

Debugger

Error Handling

Data Cleansing

Informatica PowerCenter Repository

Change Data Capture (CDC)

Creating Cubes in informatica

Handle late arriving dimensions & late arriving facts [ref]

Scenarios

How to implement SCD in informatica
* see chapter 3 in
[sanb1]

What r the advantages of ETL tools over PL/SQL loaders? [sanref1]
1. retention of metadata
2. ease of use.
3. built-ins.

ETL Life Cycle [sanref2]

Questions you should ready for interview 
[sanref7]

we can create multiple integration service in our project. check why we need multiple int services. what is benefit of it.
how can we ensure data quality in DWH or informatica.

Books:
[sanb1] [Learning Informatica PowerCenter 9.x -Rahul Malewar] [https://www.packtpub.com/big-data-and-business-intelligence/learning-informatica-powercenter-9x]

Documentation:


[https://marketplace.informatica.com/index.jspa] Informatica MarketPlace

References:

[sanref1] [https://www.information-management.com/news/what-are-the-advantages-of-etl-tools-over-pl-sql-loaders#Login]
[sanref2] [http://informatica-kareem.blogspot.com.au/2012/08/cycle-typical-real-life-etl-cycle.html]
[sanref3] [http://informatica-kareem.blogspot.com.au/2012/10/informatica-real-time-project.html]
[sanref4] [http://informatica-kareem.blogspot.com.au/2012/10/etl-project-data-warehousing.html]
[sanref5] [https://drive.google.com/viewerng/viewer?a=v&pid=sites&srcid=ZGVmYXVsdGRvbWFpbnxpbmZvZXRsMjAxMnxneDo2NGEyMjkzYmRjOGM5ZA]
[sanref6] [http://informatica-kareem.blogspot.com.au/2012/08/unit-testing.html]
[sanref7] [http://informatica-kareem.blogspot.com.au/2012/08/informatica-real-time-interview.html]
[sanref8] [http://informatica-kareem.blogspot.com.au/2013/01/scd-type1-mapping.html]
[sanref9] [http://informatica-kareem.blogspot.com.au/2013/01/scd-type-1-implementation-in_418.html]

[http://www.geekinterview.com/Interview-Questions/Data-Warehouse/Informatica] Informatica Interview Questions
[http://a2zinformatica.blogspot.in/2015/01/pivot-data-using-informatica.html] Pivot Data Using Informatica
[http://www.bullraider.com/database/informatica/scenario/9-informatica-scenario1] Convert single row from source to three rows in target
Best Informatica Interview Questions & Answers (https://dwbi.org/etl/informatica/131-important-practical-interview-questions)
[https://network.informatica.com/message/117371#117371] How to view Informatica logs
[1] HOW TO: Check if session performs slow due to disk I/O issue
[1] HOW TO: Use MetaQuery in Support Console to extract information related to Object level property from PowerCenter Repository