opbang

 Profile Answers by opbang 

• Sep 21st, 2006

 

Power Center Architecture can be divided into two sub Architecture

1. Informatica Repository Architecture

2. Informatica Server Architecture.

 

Server 1   -    Oracle Database Server

Server 2   -    Informatica Repository Server

Server 3   -    Informatica Server

1.      After installing Informatica, from Repository Server Administration Console (RSAC) create Repository in Oracle Database Server.  

2.      From Repository Manager, Create folder in Repository.

3.      You can create separate folders for each project.

All ETL work is stored in repository.

Informatica Server architecture has following 5 components. 

1.      Temp Server

2.      Reader

3.      Data Transformation Manager DTM

4.      Loader

5.      Server Agent

During Workflow session all DTM process takes place in Temp Server. Reader Reads the data from Source and Loader Loads the data on Target. Server Agent monitors the Reader and Loader activity.

Informatica ServerInformatica Server Service is only required when you are running workflow session. I

jayapraveen

 Profile Answers by jayapraveen 

• Nov 21st, 2010

 

architecture of informatica is as follows

1

1. Source Systems: Like Mainframe,Oracle,People soft,DB2.

2. Landing tables: These are tables act like source. Used

for easy to access, for backup purpose, as reusable for

other mappings.

3. Staging tables: From landing tables we extract the data

into staging tables after all validations done on the data.

4. Dimension/Facts: These are the tables those are used for

analysis and make decisions by analyzing the data.

5. Aggregation tables: These tables have summarized data

useful for managers who wants to view monthly wise sales,

year wise sales etc. 

6. Reporting layer: 4 and 5 phases are useful for reporting

developers to generate reports. I hope this answer helps you.

: