2.6 PowerCenter 9.6.1 Installation Steps
Informatica Power Center 9.6.1 Installation Steps ************************************************** Table of Contents Overview This document is for informatica administration team, providing the detailed steps on installation of Power Center 9.6.1 on Linux & Oracle Environment. Pre Installation Steps Download Software Download Software from informaticaCorporation and make sure to get proper keys based on environment (Dev/ […]
3.15 How to Read MS Access or Excel Files from Informatica PowerCenter
Using Informatica Power Center we can read MS Access or MS Excel files directly and below are the options to read from UNIX environment. 1. Informatica Power Channel – Separate License is required for setup 2. SequeLink – Using SequeLink, you can use the data source residing on a Windows machine from PowerCenter that runs […]
3.14 Steps to migrate Repository (MS Windows Latin1) to Unicode Repository
Steps to migrate Repository (MS Windows Latin1) to Unicode Repository Take backup of the already existing MS Windows Latin1 repository (Source Repository) Copy of Repository Backup File to Target Location Delete the contents of the existing repository. This step makes sure that the database schema is empty and you can restore the contents of the […]
3.4 How to delete duplicate Integration services
1. Take back up of the following tables and perform the below delete statements to delete log tables. DELETE FROM OPB_SESS_TASK_LOG; DELETE FROM OPB_SWIDGINST_LOG; DELETE FROM OPB_DTL_SWIDG_LOG; DELETE FROM OPB_TASK_INST_RUN; DELETE FROM OPB_WFLOW_VAR_RUN; DELETE FROM OPB_WFLOW_DEP_RUN; DELETE FROM OPB_WFLOW_CACHE; DELETE FROM OPB_WFLOW_RUN; COMMIT; 2. Execute the below query for the list of integration services list […]
3.19 PC86 – Purge older versions of objects in a versioned PowerCenter Repository
pmrep connect -r Repo_Name -d Domain_Name -n Administrator -x Pwd> test.out pmrep purgeversion -n -f > test1.out last_n_versions_to_keep — Number of latest checked-in object versions to keep for an active object in the folder specified (note: -f is an optional feature). The value must be an integer greater than 0. For example, enter 5 to purge all […]
3.18 PC86 – Informatica Services Not able to Start
Informatica Repository and Integration Services will be Not able to Start and you can view below error codes in admin console and server logs ERROR CODES: [CNX_53021 ],[DOM_10022], [LGS_10048],[DOM_10055],[SPC_10050],[SPC_10013],[SPC_10008] and [InfPrivilegeSynchronizationEngine] Logs: Admin Console: ERROR Mon Sep 24 00:00:33 2012 1833290048 CNX_53021 Received an invalid request. Service Manager ERROR Mon Sep 24 04:07:21 2012 Thread 2 of 6 in DomainServiceThreadPool DOM_10055 Unable […]
DM: Part 4.5 Physical Data Modeling
Physical Database Design Physical database design is the process of developing a set of required data structures on a selected database. It involves the following tasks: Converting entities into tables Converting relationships into foreign keys Converting attributes into columns Defining constraints The purpose of physical design is to optimize performance as closely as possible. Along […]
DM – Part 4.4 Logical Data Modeling
Introduction to Logical Model Logical Data Model refers to the actual implementation of a conceptual module in a database. It represents normalized design of common data model which is required to support the design of an information system. The very core of the logical data model is the definition of the three types of […]
DM: Part 4.3 Dimensional Data Model
4.3 Dimensional Data Modeling 4.3.1 Steps in Dimensional Modeling 4.3.2 Star Schema & Snowflake Schema4.3.3 The Implementation Approach (Bill & Ralph)4.3.4 Dimensional Modeling Fundamentals4.3.4.1 Dimensional Modeling Overview 4.3.4.2 Dimensional Modeling Steps 4.3.5 Confirmed Dimensions4.3.6 Slowly Changing Dimension 4.3.7 Additivity of Measures4.3.8 Dimensional Modeling framework 4.3.1 Steps in Dimensional Modeling 4.3.2 Star Schema & Snowflake […]
Dm – Part 4.2 Relational Data Modeling
4.2 Relational Data Modeling 4.2.1 Relational Data Model Concepts 4.2.2 ER to Relational Mapping Algorithm 4.2.3 Relational Database Design 4.2.3.1 Relational Database Design Approach 4.2.3.2 Normalization 4.2.1 Relational Data Model Concepts Relation Data Model A relational data model is a representational or implementation or record-based data model The model uses the concept of a mathematical […]