Informatica Powercenter – Aggregator Transformation

In the image above we can see inside of a aggregation transformation in Informatica Powercenter. So Aggr transformation can be any of those, Avg, Count, First, last, SUM, etc. For our example I will use this as baseline: We have the SQ_EMP_FILE table and here’s how I want this table to look like after myContinuar lendo “Informatica Powercenter – Aggregator Transformation”

Informatica Powercenter – Source Qualifier Trasformation

Here’s what the official documentation says about Source Qualifier transformation: The Source Qualifier transformation represents the rows that the Integration Service reads when it runs a session. The Source Qualifier transformation is an active transformation. So, Source Qualifier happens when you drag a source to the mapping designer. Here’s our source: Here’s what happens whenContinuar lendo “Informatica Powercenter – Source Qualifier Trasformation”

Informatica Powercenter – Display Language

So, I’ve been trying to change my Informatica Powercenter display language from Portuguese to English, however I never could find a decent way of doing this trough reg or properties file editing, so I end up doing the normal way, which is, changing your Windows’ Region format . Here’s a print screen using my computer,Continuar lendo “Informatica Powercenter – Display Language”

Informatica Powercenter – Expression Transformation

First post of the many to be on Informatica Powercenter, starting right with Expression Transformation. In this scenario our goal is to get data from a flat file, transform it using expressions and then load into our database the result of that transformation. First, we need: a source, then a target, then this target needsContinuar lendo “Informatica Powercenter – Expression Transformation”

Informatica PowerCenter Data Integration 10 Developer, Professional Certification

So, I’m trying to put some study together in order to get Powercenter Data Integration certified. I have done some searching in the past and Informatica documentation is not like Microsoft’s one, it looks like a bit more complicated. Link: https://now.informatica.com/PowerCenter-Data-Integration-10-Developer-Professional-Certification.html Note: here’s a guide on Informatica Powercenter first steps, including installation. https://powerbixpert.com/tag/powercenter/ Test TopicsContinuar lendo “Informatica PowerCenter Data Integration 10 Developer, Professional Certification”

Azure AZ-900 Describe core resources available in Azure | Marketplace

Este é o segundo tópico do módulo “Describe Core Azure Services (15-20%)”. Para encontrar todos outros posts para estudo da certificação Azure AZ-900 acesse: Azure AZ-900: Microsoft Azure Fundamentals Describe Core Azure Services (15-20%) Describe core resources available in Azure describe the benefits and usage of Azure Marketplace fonte:https://docs.microsoft.com/en-us/learn/modules/simplify-cloud-procurement-governance-azure-marketplace/ Azure Marketplace é um lugar ondeContinuar lendo “Azure AZ-900 Describe core resources available in Azure | Marketplace”

Azure AZ-900 Describe core resources available in Azure | Database and Analytics

Este é o segundo tópico do módulo “Describe Core Azure Services (15-20%)”. Para encontrar todos outros posts para estudo da certificação Azure AZ-900 acesse: Azure AZ-900: Microsoft Azure Fundamentals Describe Core Azure Services (15-20%) Describe core resources available in Azure describe the benefits and usage of Cosmos DB, Azure SQL Database, Azure Database for MySQL,Continuar lendo “Azure AZ-900 Describe core resources available in Azure | Database and Analytics”

Azure AZ-900 Describe core resources available in Azure | Storage

Este é o segundo tópico do módulo “Describe Core Azure Services (15-20%)”. Para encontrar todos outros posts para estudo da certificação Azure AZ-900 acesse: Azure AZ-900: Microsoft Azure Fundamentals Describe Core Azure Services (15-20%) Describe core resources available in Azure describe the benefits and usage of Container (Blob) Storage, Disk Storage, File Storage, and storageContinuar lendo “Azure AZ-900 Describe core resources available in Azure | Storage”

Azure AZ-900 Describe core resources available in Azure | Compute

Este é o segundo tópico do módulo “Describe Core Azure Services (15-20%)”. Para encontrar todos outros posts para estudo da certificação Azure AZ-900 acesse: Azure AZ-900: Microsoft Azure Fundamentals Describe Core Azure Services (15-20%) Describe core resources available in Azure describe the benefits and usage of Virtual Machines, Azure App Services, Azure Container Instances (ACI),Continuar lendo “Azure AZ-900 Describe core resources available in Azure | Compute”

Azure AZ-900 Describe core resources available in Azure | Network

Este é o segundo tópico do módulo “Describe Core Azure Services (15-20%)”. Para encontrar todos outros posts para estudo da certificação Azure AZ-900 acesse: Azure AZ-900: Microsoft Azure Fundamentals Describe Core Azure Services (15-20%) Describe core resources available in Azure describe the benefits and usage of Virtual Networks, VPN Gateway, Virtual Network peering, and ExpressRouteContinuar lendo “Azure AZ-900 Describe core resources available in Azure | Network”