AWS Certified Solutions Architect Associate SAA-C03 | Well-Architected Framework

Here are some basics links for AWS Well-Architected Framework: Overview – Docs – Whitepaper – AWS Well-Architected Framework Pillars We must know all pillars, but pay some special attention to Sustainability.

AWS Certified Solutions Architect Associate SAA-C03 | Overview

Below are the basic details about the exam.  Format: Multiple choice and multiple response questions only Type: Associate Delivery method: Pearson VUE testing center or online proctored exam Number of questions: 65 Time: 130 minutes Cost: 150 USD Languages offered: English, French (France), German, Italian, Japanese, Korean, Portuguese (Brazil), Simplified Chinese, Spanish (Latin America), SpanishContinue reading “AWS Certified Solutions Architect Associate SAA-C03 | Overview”

AWS Certified Solutions Architect Associate SAA-C03 | Glossary

Another certification I’m working on, the AWS Associate Solution Architect. You can find more about it here: Here are some topics and terms (I’m calling this Glossary for simplicity) I would like to write down so we can start having a more foundational, basic, understanding of what AWS Solution Architect should know about. GlossaryContinue reading “AWS Certified Solutions Architect Associate SAA-C03 | Glossary”

Google Cloud Digital Leader Certification – My resume

I am studying for this Google Cloud Digital Leader Certification, as I understand, this is like AZ 900 but from Google. Here is the exam breakdown, every topic they say they can charge on the exam: In this post I will explain all topics with my own words, try to provide links and etc,Continue reading “Google Cloud Digital Leader Certification – My resume”

Azure DP-900: Microsoft Azure Data Fundamentals | Notes and Highlights

Just passed Azure DP-900 exam! Here is what and how I did it: And here are all notes I’ve taken during my study process: Document Data Store Azure Storage Azure SQL Database Graph Database Azure HDInsight Azure Data Explorer Azure Table Storage Key / Value Data Store Spark Structured Streaming Azure Cosmos DB

Azure AZ-900: Microsoft Azure Fundamentals | Notes and Highlights

Just passed AZ-900 certification!! I have written a page on all my tips and notes to help you get through as well, check it out here: Notice that not all topics are covered there. What I suggest, and the best way I see to take advantage of these notes, is: Have fun, good luck!

Informatica Powercenter – XML Transformation (XML Source Qualifier, XML Parser, XML Generator)

I highly recommend reading the first three links on References, at the end of this post. About XML What says the official documentation: “Each group in an XML source definition is analogous to a relational table, and the Designer treats each group within the XML Source Qualifier transformation as a separate source of data.” TheContinue reading “Informatica Powercenter – XML Transformation (XML Source Qualifier, XML Parser, XML Generator)”

Informatica Powercenter – Stored Procedure Transformation

Let’s start checking out what the official documentation has to say: “A Stored Procedure transformation is an important tool for populating and maintaining databases. Database administrators create stored procedures to automate tasks that are too complicated for standard SQL statements. The Stored Procedure transformation is a passive transformation. You can configure a connected or unconnectedContinue reading “Informatica Powercenter – Stored Procedure Transformation”

Informatica Powercenter – SQL Overrides

I did not really find any super good resource on this topic, but the overall idea of SQL override is to override a transformation default behavior by writing a SQL query instead. Of course, SQL overrides works only on relational data. There is no SQL Overrides for flat file. For instance, take a source qualifierContinue reading “Informatica Powercenter – SQL Overrides”

Informatica Powercenter – User Defined Functions

User Defined Function (UDF’s) is a way Powercenter gives us to create our own personal, reusable, functions. We can use our UDF’s in Expression Transformations in order to reuse expression logic. For instance, if you want to RTRIM() LTRIM() and UPPER() several ports, so, instead of writing all these 3 functions all the time youContinue reading “Informatica Powercenter – User Defined Functions”

Informatica Powercenter – Mapplets

Here what official documentation says about Mapplets: A mapplet is a reusable object that you create in the Mapplet Designer. It contains a set of transformations and lets you reuse the transformation logic in multiple mappings. When you use a mapplet in a mapping, you use an instance of the mapplet. Any change made toContinue reading “Informatica Powercenter – Mapplets”

Informatica Powercenter – Update Strategy Transformation SCD1 SCD2

Something worth keeping in mind: in order to Update Strategy to work properly you need to make sure that your target table has a primary key. Here’s what the official documentation says about Update Strategy Information: “The Update Strategy transformation is an active transformation. When you design a data warehouse, you need to decide whatContinue reading “Informatica Powercenter – Update Strategy Transformation SCD1 SCD2”