DM – Part 4.1 Conceptual Data Modeling
4. Data Modeling 4.1 Conceptual Data Modeling 4.1.1 Introduction to Conceptual Data Model 4.1.2 Stages in Conceptual Modeling 4.1.3 Components of a Conceptual Data Model 4.1.4 ER Modeling Basic Concepts 4.1.5 Enhanced ER Modeling 4.1.6 Guidelines for ER Modeling 4: 4.1 Conceptual Data Model Conceptual Data Model A conceptual schema or conceptual data […]
DM – Part 3: How to Data Model
3.1: Identify Entity Types Entity Object that can be observed and classified by its properties and characteristics Business definition with a clear boundary Characterized by a noun Example: Product, Employee 3.2: Identify Attributes Attributes Characteristics and properties of entities Example : Book Id, Description, book category are attributes of entity “Book” Attribute name should […]
DM – Part 2: Data Model
Advanced Data Modeling and Architecture Table of Contents Part 1: Data Modeling Overview 2.1 : Definition of a Data Model Model Representation of a set of business requirements in a standard structured framework understood by the users Data Model A collection of concepts that can be used to describe the structure of a database […]
DM – Part 1: Data Modeling Overview
Advanced Data Modeling and Architecture Table of Contents 1.1: Prerequisites for this Session Pre-Requisites Should be aware of DBMS ConceptsS Should be aware of Data warehouse concepts Should be aware of Data base concepts (any database) Should have 2+ years of experience on any ETL Tool 1.2 : Expectations from Session 1.3: Scope of […]
DM: Advanced Data Modeling and Architecture
Session Title: Advanced Data Modeling and Architecture Pre-requisites ü Should be aware of DBMS Concepts ü Should be aware of Data warehouse concepts ü Should be aware of Data base concepts (any database) ü Should have minimun of 2+ years of experience on any ETL Tool Table of Content 1. Data Model Overview 1.1 Prerequisites for this […]
Informatica PC HF4 Installation Steps on PC91HF3
Table of Contents Overview This document isfor informatica administration team, providing the detailed installations stepsof HotFix 4 on PC 91 HF3 Download 9.1 Software Download Softwarefrom informatica Corporation and make sure to get proper keys based onenvironment (Dev/ Prod). Backup Domain Before Startup take all backups of domainand Repositories Backup of Repositories’ Take backup of […]
How to find Sources and Targets of a Session
Please use below steps to find out source and target of a session using pmrep commands. Connect to Linux Server and log in to bin folder ($INFA_HOME/Server/bin) Connect to Repository, using below commandpmrep connect -r <REPO NAME> -d <DOMAIN NAME> -n <USER> -x <PWD> Fetch Source tables of the sessionpmrep listtablesbysess -f <Folder Name> -s <Session Name> […]
3.03 Tuning Repository Performance
Repository Analyze The PowerCenter repository has more than 170 tables, and almost all tables use at least one index to speed up queries. Most databases keep and use column distribution statistics to determine which index to use to execute SQL queries optimally. Database servers do not update these statistics continuously. In frequently used repositories, these […]
Informatica PC Upgrade from 861 to 91 Installation Steps
Table of Contents Overview This document isfor informatica administration team, providing the detailed upgradation steps from8.6.1 to 9.1 on Linux & Oracle Environment. Download 9.1 Software Download Softwarefrom informatica Corporation and make sure to get proper keys based onenvironment (Dev/ Prod). Backup Domain Before Startup of up gradation, please takebackup of 8.6.1 domain Backup of […]
Informatica PC 861 Instellation Steps
Table of Contents Overview This document is for informatica administration team, providing the detailed steps on installation of Power Center 8.6.1 on Linux & Oracle Environment. Download Software Download Software from informatica Corporation and make sure to get proper keys based onenvironment (Dev/ Prod). Setup of Database Parameters, Users & Tablespace Database Parameter Set the open_cursors parameter to 1000 […]