DronaBlog

Sunday, March 21, 2021

Understanding Timeline in Informatica MDM

Timeline is one of the useful features in Informatica Master Data Management. It enables us to manage various versions of the business records. The timeline is totally different from the history of the records updates and inserts. In this article, we will focus on Timeline granularity and Timeline actions features. So let's dive in.


Timeline Granularity

In Informatica MDM, We use time measurement such as years, months, days, etc to define effective periods for versions of records. This time measurement is nothing but timeline granularity. We can define timeline granularity as a year, month, day, hour, minute, or seconds.




Timeline Action

The timeline action is nothing but an action to perform for entities for which you track data change events. We can perform add, edit actions on a record and edit effective period. 

a. Timeline action = 1 --> This value is set if we update the data
b. Timeline action = 2 --> This value is set if we update Effective Period
c. Timeline action = 4 --> This value is set if we Add Effective Period

Versioning Sequence :

The stage table column VERSION_SEQ  is set to 1 by default and gets changed based on the new update.


Learn more interesting facts about Informatica MDM Timeline



Monday, February 15, 2021

What are the different phases of Informatica MDM Implemantion


Are you planning to implement the Informatica Master Data Management project? Are you looking for what are the details you need to capture? If so, then you reached the right place. In this article, we will understand what are the phases of Informatica MDM implementation. We will also see what will be the outcome of each phase.


Introduction:

There are 5 phases in Informatica Master Data Management implementation.




1. Discovery Phase
2. Design Phase
3. Development Phase
4. Testing Phase
5. Deployment Phase



Let's understand each of these phases one by one.


A. Discovery Phase:

We need to perform the activities below as part of the discovery phase -
  • Perform data profiling
  • Conduct interviews and workshops 
  • Document solution requirements 
  • Define conceptual architecture 
  • Define the logical data model 

What will be output?
The output of this phase will be 1. Functional Requirements Specification 2. Testing Plan


B. Design Phase:

We need to perform the activities below as part of the Design phase -
  • Define detailed business rules 
  • Develop system design specifications for all technology components 
  • Develop Traceability Matrix 
  • Establish DEV Environment 

What will be output?
The output of this phase will be 1. System Design Specification 2. Traceability Matrix

C. Development  Phase:

We need to perform the activities below as part of the Development phase -
  • Configure and develop MDM components
  • Perform unit testing
  • Develop Test Scripts 
  • Develop Test Schedule 
  • Update Traceability Matrix 
  • Establish QA and PROD Environment 

What will be output?
The output of this phase will be 1. Configured and developed MDM components 2. Test Scripts 3. Traceability Matrix





D. Testing Phase:

We need to perform the activities below as part of the Testing phase -
  • Execute System Testing 
  • Execute Rules Testing 
  • Execute Integration Testing 
  • Execute User Acceptance Testing 
  • Develop Test Summary Report 

What will be output?
The output of this phase will be 1. Tested, production-ready MDM solution 2. Test Script Results 3. Test Summary Report 

E. Deployment Phase:

We need to perform the activities below as part of the Deployment phase -
Deploy the Solution into the Production Environment 
Execute the initial IDL Initiate 
Gray Area Reconciliation 

What will be output?
The output of this phase will be  1. Deployed solution Initial data loaded and ready for reconciliation





You can learn more about Informatica Master Data Management here -



Thursday, January 21, 2021

Informatica MDM Installation Checklist


 Are you looking for an article about how to prepare a checklist for Informatica MDM Installation? You might have gone through the Informatica MDM Installation guide and must be facing issues from where to start. The best way to start is nothing preparing checklist. In this article, we will see what are the main topics to consider for check and we will also see a sample checklist file.





Introduction

After going through more than 100 pages in the Installation guide, I realized that we need to prepare a checklist for each component of Informatica MDM. Informatica MDM comes with Hub Server, Process Server, Informatica Data Director Configuration Manager, Provisioning Tool, Business Process Management i.e. Active VOS, Elastic Search, Application Server (such as Jboss, WebSphere, Weblogic), Database (such as SQL Server, DB2, Oracle). Each of these components has a separate set of instructions. Sometimes we get lost or overwhelmed with all these instructions. So take a long breath and start documenting the main section as like mentioned in our next section

Components to consider for installation

The number of components that are needed for installation is based on the business needs. However, there few components are commonly required irrespective of business need e.g. Process Server, Hub Server. So first document all possible components which you are planning to install. Here is a sample list of components. 


Informatica MDM Installation checklist

The checklist contains details about each of the components which are captured in the previous section. e.g. Create the MDM Hub Master Database section will have details about database name, server name, port, and credentials. You can access the complete checklist here.


For reference, the checklist will look like as below





If you are looking for more details about Informatica MDM then here is a video for Informatica MDM.







Tuesday, January 19, 2021

Join Conditions in Snowflake

 Are you looking for an article about the type of Join conditions in Snowflake? Are you also would like to understand these different types of join conditions in detail? If so, then you reached the right place. In this article, we will understand various join conditions used in Snowflake.





Introduction:

As like DBMS, Snowflake supports various types of join conditions. Join condition allow us to combine data from two or more tables. In Snowflake, there is no association between the tables using the primary key and foreign keys but we can still use the join condition.


Type of Join in Snowflake:

  • Inner Join
  • Outer Join
    • Left Outer Join
    • Right Outer Join
    • Full Outer Join
Let's understand each Type of Join with help of the Venn diagram

Understanding Syntax for Join Condition

Using the join condition in the SELECT statement is command practice. After writing the SELECT statement in the FROM clause we need to provide a table name then followed by the JOIN keyword. We also need to provide details on which column we need to perform join by using an ON clause. Here is the syntax for the join condition in Snowflake.




A. Inner Join

The Inner join in Snowflake is used to return rows from both tables which satisfy the condition. 

Example:
SELECT CUST.CUST_NBR
, CUST.FIRST_NAME
, CUST.LAST_NAME
, ADDR.AD_LINE_1
, ADDR.COUNTRY
FROM CUSTOMER CUST
INNER JOIN ADDRESS ADDR
ON CUST.CUST_NBR = ADDR.CUST_NBR.

The above query returns the elements which common between the CUSTOMER and ADDRESS tables.


B. Outer Join

If two tables do not contain all the records then we use an OUTER JOIN. Each table contains records even if the other table does not contain any corresponding record. The outer Join is subcategorized as 
  1. Left Outer Join
  2. Right Outer Join
  3. Full Outer Join
Let's understand these Outer join one by one.

1. Left Outer Join

The LEFT JOIN in Snowflake returns all the rows from the table on the left side of the equation even if there are no matching rows in the table on the right side of the equation.



Syntax

SELECT CUST.CUST_NBR
, CUST.FIRST_NAME
, CUST.LAST_NAME
, ADDR.AD_LINE_1
, ADDR.COUNTRY
FROM CUSTOMER CUST
LEFT OUTER JOIN ADDRESS ADDR
ON CUST.CUST_NBR = ADDR.CUST_NBR.





2. Right Outer Join


The RIGHT JOIN in Snowflake returns all the rows from the table on the right side of the equation even if there are no matching rows in the table on the left side of the equation
.
Syntax
SELECT CUST.CUST_NBR
, CUST.FIRST_NAME
, CUST.LAST_NAME
, ADDR.AD_LINE_1
, ADDR.COUNTRY
FROM CUSTOMER CUST
RIGHT OUTER JOIN ADDRESS ADDR
ON CUST.CUST_NBR = ADDR.CUST_NBR.

3. Full Outer Join

The FULL OUTER JOIN in Snowflake returns all the rows from both tables irrespective of condition match.
Syntax
SELECT CUST.CUST_NBR
, CUST.FIRST_NAME
, CUST.LAST_NAME
, ADDR.AD_LINE_1
, ADDR.COUNTRY
FROM CUSTOMER CUST
FULL OUTER JOIN ADDRESS ADDR
ON CUST.CUST_NBR = ADDR.CUST_NBR.


















Learn more about Snowflake here

Saturday, December 26, 2020

How to create Orchestration Project in Informatica Active VOS Designer?

 Are you looking for the details about how to create Orchestration Project in Informatica Active VOS Designer? If so, then you reached the right place. In this article, we will see how to create our first Orchestration project. We will also discuss various types of Orchestration project we can create using Designer.





Step 1: Go to Active VOS Designer tool and then select File > New > Orchestration Project, and click Next.

 



 

Step 2: A new dialog box will open. Provide a name to the project and then click on ‘Next’ button.



 

Step 3: New Orchestration Project template will be shown on the screen and it includes

Default Orchestration, Java Enabled Orchestration, Tutorial, Tutorial Completed, Human Approval, Human Approval Completed, On Event Adjust Threshold, User Reports and Custom Function and XQuery

Select Default Orchestration and Click on ‘Finish’ Button



 





Step 4: The project will be displayed in the Project Explorer view in the Designer tool



 

Step 5: Expand the project by clicking an arrow on the left side of the Project Name. We will see multiple folders under the project and those are Service References, BPEL, deploy, form, sample-data, schema, test, WSDL, XQuery, XSL. All these folders will be empty. Each of these folders has a specific purpose. Project-specific files are stored in each of these relevant folders.








Learn more about Active VOS here -





 

 

Sunday, December 20, 2020

What is BPEL in Informatica Active VOS?

 

Are you interested in knowing what BPEL process in Informatica Active VOS is? Are you also would like to know what is structure and version of BPEL currently available in the market? If so, then you reached the right place. In this article, we will understand more about the BPEL process.






What is BPEL?

BPEL stands for Business Process Execution Language. Based on Web Service protocols we can define XML notations for Business Process Execution Language for Web Services (i.e. BPEL).

·         BPEL the specification is used as the standard in Web Services architecture

·         BPEL provides details about process-specific language constructs

·         BPEL is also used to define how multiple web services can be composed into coherent information system.

 

What is BPEL Version?

The current version BPEL is 2.0. The standard of BPEL language is based on the following specification

1)    Web Services Description Language Version 1.1.

2)    XPath

3)    XML Schema

 

What is BPEL Process?

Now we understand what is BPEL, let’s understand what BPEL Process is. A BPEL process is a collection of multiple Web Services. Each of the Web Service in this collection performs specific processing. These web services can be granular or complex.

 

Understanding BPEL Process with Example

In the figure below, the Customer places an order online using a Laptop or a similar device. This internally calls a web service. The web service receives and requests and acknowledgments that are communicated back to the Customer. At the same time Place Order process gets started. As soon the Place Order request is executed the communication will be sent to the Customer about the placement of an order in the form of an order number or receipt. The Place Order process internally will call another web service which will connect to the external supplier or provider of the item to the Customer. Finally, the order will be fulfilled with help of these systems communicating with each other. The execution of the customer buying experience can be filled with a proper mechanism using BPEL Process.

 



 





What are the important components of BPEL language?

The listed below are the components of BPEL language

·         Partner Links: Used to define roles of process participants

·         Variables: Variables used within the process

·         Correlation Sets

·         Faulted Handler: In order to handle exceptions

·         Event Handler: Used for handling messages and timeout events

·         Activities: Actual processing steps

 

Sample code for BPEL Language

Here is sample code for BPEL

<process>

<!-- Definition of roles of process participants -->

<partnerLinks> ... </partnerLinks>

<!-- Data and state variables used within the process -->

<variables> ... </variables>

<!-- Correlation comment -->

<correlationSets> ... </correlationSets>

<!-- Exception management -->

<faultHandlers> ... </faultHandlers>

<!-- Message and timeout event handler -->

<eventHandlers> ... </eventHandlers>

<!-- Processing steps -->

Actual processing steps

</process>

 

 

 

 









 


Saturday, December 12, 2020

How to prepare for Informatica MDM Developer Certification?

 If you planning to get Informatica MDM Developer certified and wanted to know how to prepare for Informatica MDM Developer Certification. If so, then you reached the right place. In this article, we will discuss all the topics on which Informatica Master Data Management certification is based on. We will also discuss the Informatica MDM Certification cost. With that, I would like to congratulate very first steps towards your MDM Developer certification and good luck with your exam.






Introduction

In this article, we will discuss all the topics on which questions will be asked in the certification examination. We will provide the necessary video tutorial and other material. With help of this material and proper training, you will be ready for your certification. You do not have to look for Informatica MDM certification dumps and avoid online frauds. You can find Informatica MMD training online either on Udemy or other platforms. You can also take training from Informatica but these are a little expensive. The Informatica Certification exam includes questions that are multiple-choice, multiple responses, or true/false formats. The exam has 70 questions with a passing score of 70 percent. The duration of the exam is 90 minutes. The exam access will expire 90 days after purchase, with no refund.


Informatica MDM Certification cost

Informatica MDM Certification costs $340 USD, it includes a second free attempt. After that, if you would like to attempt again then the original cost will apply. This cost varies from time to time, so this cannot be a guaranteed price.

Informatica MDM Developer Certification

In this section, we will discuss the Informatica MDM syllabus. I would strongly recommend going through these topics before taking any Informatica MDM training online or attending any Informatica certification program. If you already working on the MDM project and have good experience in Informatica MDM real-time projects then it will be easy to get certified. 





A. Introduction to MDM Multidomain Edition

E. Overview of Match and Merge Processes

F. Fuzzy matching

G. Configure of queries and packages

H. User Objects

I. Introduction to Entity 360

J. MDM Entity 360 Architecture





What is CRM system?

  In the digital age, where customer-centricity reigns supreme, businesses are increasingly turning to advanced technologies to manage and n...