DK_Reddy

 Profile Answers by DK_Reddy Questions by DK_Reddy

• Apr 19th, 2009

 

ETL-Extraction (from Source)-Transformation-Loading (to Target)
In this process There are 2 servers active at the same time
1) Informatica Server.

2) Repository Server

Here Informatica Server Connects to the Sources and Targets through Native ODBC connections, Again Informatica server connects to the Repository server,
In this sequence, Repository Server Connects to its repositories (for metadata), and repository administrator
console (for security checks-Like privileges to users to do this transformations etc.)

vijaykumar2009

 Profile Answers by vijaykumar2009 

• Dec 9th, 2009

 

ETL complete process done as fallows:
In INFORMATICA POWER CENTER DESIGNER 
Creation of source table
Creation of target table
Creation of mapping :plan of implement business logic         

Takes place and that information is stored in repository
In INFORMATICA WORKFLOW DESIGNER
Creation of task (session): which is availability of running the mapping
Creation of workflow: which is used to execute the session
Takes place and that are stored in repository and 
Workflow and session details are send to INTEGRATION SEVER for computing business logic
INTEGRATION SERVICE  get data of source by requesting from REPOSITORY SERVICE
REPOSITORY SERVICE get data from REPOSITORY and submit to INTEGRATION SERVICE
REPOSITORY SERVICE  transform the data for BUSINESS LOGIC IMPLEMENT PURPOSE in STAGING AREA and send data to target table to see the transformation execution details whether it is successfully executed or not that can be done through WORKFLOW MONITOR
WORKFLOW MONITOR is used to monitor the session log details and session, workflow details.

Answer submitted by
VIJ@Y KUMAR