Informatica Powercenter 10.4.1 Basics – First Steps

The Informatica Powercenter is a 4 post series, see all posts clicking here. Before starting creating workflows and integrations let’s create our repository, here’s how. Open PowerCenter Repository Manager. Click to add new repository. Right click your Repository and add domain. Connect to your repository, Administrator / Administrator should do it. Select your REP andContinuar lendo “Informatica Powercenter 10.4.1 Basics – First Steps”

Informatica Powercenter 10.4.1 Basics – Install Client

The Informatica Powercenter is a 4 post series, see all posts clicking here. Now that we have Informatica Powercenter Server already installed, let’s proceed with Informatica Powercenter client. Here I show how. Go to the files you have downloaded and find this path: \part1\informatica_1041_client_winem-64t\Client That’s it, next next finish, and your client will be installed.

Informatica Powercenter 10.4.1 Basics –Install Server

The Informatica Powercenter is a 4 post series, see all posts clicking here. Before installing Informatica powercenter client (such as the informatica powercenter designer) you need to install the Informatica Powercenter server. Here I show how. Go to the files you have downloaded and find this path: \part2\informatica_1041_server_winem-64t\Server\ Double click install.exe. On step 6, ifContinuar lendo “Informatica Powercenter 10.4.1 Basics –Install Server”

Informatica Powercenter 10.4.1 Basics – Where to download?

The Informatica Powercenter is a 4 post series, see all posts clicking here. You can download INFORMATICA POWERCENTER at: https://edelivery.oracle.com/osdc/faces/SoftwareDelivery Search for: “Oracle Informatica PowerCenter and PowerConnect Adapters” Select your software > click on top right “continue”. On the new page, select your Operational System > continue. On the new page >  accept the terms.Continuar lendo “Informatica Powercenter 10.4.1 Basics – Where to download?”

Data Warehouse ETL Toolkit – Chapter 03 – Part 1

Chapter 03 – Extracting Integrating all the different data sources are usually one of the biggest challenges the ETL team faces, and without data there is not data warehouse. In this chapter Kimball teach us how to interface with those various source systems, how to create your logical data map and how to deal withContinuar lendo “Data Warehouse ETL Toolkit – Chapter 03 – Part 1”

Data Warehouse ETL Toolkit – Chapter 02

Chapter 02 – ETL Data Structures In this chapter Kimball start once again talking about staging data, which he says that (sic) in this context staging means writing to disk. He also reminds us that they recommend 4 staging points, between each major steps of the ETLS (ECCD). This chapter focus on describing general designContinuar lendo “Data Warehouse ETL Toolkit – Chapter 02”

Data Warehouse ETL Toolkit – Chapter 01

Hello everyone, I’m trying to improve my english skills, so from now on I will try to in english write as much as possible. I’m also reading Kimballs’ and Casertas’ “The Data Warehouse ETL Toolkit”, and here I will post my chapters summaries. Hope it can help you like its helping me 🙂 — ChapterContinuar lendo “Data Warehouse ETL Toolkit – Chapter 01”