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 andContinue reading “Informatica Powercenter 10.4.1 Basics – First Steps”
Category Archives: ETL
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, ifContinue reading “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.Continue reading “Informatica Powercenter 10.4.1 Basics – Where to download?”
Data Warehouse ETL Toolkit – Chapter 03 – Part 1 – Extracting
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 withContinue reading “Data Warehouse ETL Toolkit – Chapter 03 – Part 1 – Extracting”
Data Warehouse ETL Toolkit – Chapter 02 – ETL Data Structures
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 designContinue reading “Data Warehouse ETL Toolkit – Chapter 02 – ETL Data Structures”
Data Warehouse ETL Toolkit – Chapter 01 – Surrounding the Requirements
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 🙂 — ChapterContinue reading “Data Warehouse ETL Toolkit – Chapter 01 – Surrounding the Requirements”
Pedro Carvalho 