DronaBlog

Wednesday, January 4, 2023

How Active VOS is used in Informatica MDM?

Active VOS is a key component of Informatica's Master Data Management (MDM) platform. It is a high-performance, scalable, and flexible data integration platform that enables organizations to manage and maintain their master data across various systems and applications.





One of the main benefits of Active VOS is its ability to support real-time data integration and processing. This means that data updates can be immediately reflected in the master data repository, ensuring that all departments are working with the most current and accurate information.

In addition to real-time processing, Active VOS also offers a number of other features and capabilities that make it an ideal solution for master data management. These include:

•         Support for a wide range of data sources and targets: Active VOS can connect to and integrate data from a variety of sources, including databases, applications, and file systems.

•         Data transformation and cleansing: Active VOS includes a powerful data transformation engine that can cleanse, enrich, and standardize data to ensure that it meets the organization's quality and consistency standards.

•         Data governance and security: Active VOS includes a data governance framework that allows organizations to manage and control access to their master data. This includes the ability to set policies and procedures for data management, as well as to monitor and enforce compliance with those policies.





In terms of APIs, Active VOS offers a number of options for integration and customization. These include:

•         Active VOS REST API: This API allows developers to access and manipulate data and resources within the Active VOS platform using RESTful web services.

•         Active VOS SOAP API: This API enables integration with other systems and applications using SOAP (Simple Object Access Protocol).

•         Active VOS Java API: This API allows developers to access and manipulate data and resources within the Active VOS platform using Java.

By leveraging the capabilities of Active VOS, organizations can effectively manage and maintain their master data, ensuring that all departments are working with accurate and consistent information. This can lead to improved decision-making, increased efficiency, and better business outcomes.

                 Learn more about Informatica here 



            

                   

                

Business Benefits of Informatica MDM

Implementing Informatica Master Data Management (MDM) in an organization can provide numerous benefits to the business. Here are a few of the key advantages of using Informatica MDM:



 

Improved data quality: One of the main benefits of Informatica MDM is the ability to improve the quality of the organization's data. By establishing a single source of truth for key data entities, such as customer and product information, the organization can ensure that all departments are using consistent and accurate data. This can lead to better decision-making, increased efficiency, and reduced risk of errors.

 

Enhanced data governance: Informatica MDM includes a robust data governance framework that allows organizations to manage and control access to their data. This includes the ability to set policies and procedures for data management, as well as to monitor and enforce compliance with those policies. By establishing strong data governance, organizations can improve the security and integrity of their data and reduce the risk of data breaches.

 





Increased efficiency: Informatica MDM can help organizations streamline their data management processes, resulting in increased efficiency and productivity. By automating the process of cleansing, enriching, and standardizing data, Informatica MDM can help organizations save time and resources.

 

Better customer experiences: With accurate and consistent customer data, organizations can provide personalized and relevant experiences to their customers. This can lead to increased customer satisfaction and loyalty, as well as improved business outcomes.

 

Greater agility: Informatica MDM enables organizations to quickly and easily adapt to changing business needs. By centralizing data management, organizations can more easily respond to new data requirements and make changes to their data management processes as needed.

 

In conclusion, implementing Informatica MDM can provide numerous benefits to an organization. By improving data quality, enhancing data governance, increasing efficiency, and enabling greater agility, Informatica MDM can help organizations drive better business outcomes.

                 Learn more about Informatica here 



            

                   

                

Tuesday, August 9, 2022

What are top cloud data warehouses ?

            Are you looking for the top cloud data warehouses in the current market? Are you interested in knowing which cloud data warehouse is the preferred one? If so, then you reached the right place. Let's discuss top cloud data warehouses.





A] What is a cloud data warehouses?

            A database stored as managed service and provided as software-as-a-service (i.e SaaS) to perform analytics and business intelligence operations in a public cloud is called a cloud data warehouses.

            In some cases these can be private cloud provider services.


B] What are the cloud data warehouses? 

             Following are the currently available top cloud Data warehouses -

           1. Azure Synapse Analytics 

           2. Amazon Redshift 

           3. Google BigQuery

           4. Azure SQL database 

           5. Snowflake

           6. Azure Cosmos DB+






C] Which could Data Warehouse should we use?

    The use of Cloud Data  Warehouse depends on the business use case. However, currently, Snowflake Cloud Data Warehouse is commonly used due to the ease and performance it provides compared to other Cloud Datawarehouse.


Learn more about Snowflake Cloud Datawarehouse here.



Sunday, March 27, 2022

How does secure data sharing work in snowflake ?

               Are you looking for the details about how data sharing works in snowflake? Are you also interested in knowing what are things we can share in snowflake? If so, then you reached the right place. In this article, we will explore data sharing in Snowflake. Let's start.


A] What are the database objects we can share?

              The following snowflake database objects can be shared -

              a) External tables 

              b) Tables 

              c) Secure views 

              d) Secure UDFs

              e) Secure materialized views

             The objects which are shared are in Read-only. i.e we cannot add, update or delete data or objects.






B] How does secure data sharing work? 

             Secure data sharing is a feature of snowflake using which data is shared with consuming systems.

            Following are important points about secure data sharing.

           1. No actual data is copied or transferred

           2. Sharing achieved using snowflake unique services layer and metadata store 

           3. No storage is needed on the consumer side

           4. No monthly charges to the consumer for storage 

           5. Consumers need to pay for  executing queries i.e for using compute resources 





       How does Data Sharing work in Snowflake? 

           a) Secure data share comes with the provider and consumer concepts.

           b) Provider creates a shared database and grants access to specific objects in the database 

           c) Provider has capabilities to share from multiple databases if these databases are from the same account 

          d) The read-only database is created on the consumer side from the share. Access to this database is configurable using standard role-based access control.


Learn more about snowflake here -



Saturday, February 5, 2022

What are best Practices for Customer 360 data modeling ?

                        Are you planning to make changes in the existing customer 360 or c360 data model ? or are you thinking to extend the customer 360 data model and looking for guidelines in doing it? If so, then you reached the right place. In this article, we will understand best practices for customer 360 data modeling in Informatica Master Data Management.


A) What is Customer 360? 

                       Informatica provides a pre-designed customer domain Master Data Management (MDM) tool. Using this we can expedite the development process for MDM implementation in our organization. Customer 360 comes with a prebuilt data model which we can either update or extend as needed.

                      Customer 360 MDM also comes with a user interface called customer 360 application and it is based on business entity services.

                      There are multiple aspects we need to consider while updating or extending the customer 360 data model and we are going to discuss this in this article.






B) What are the steps for modifying the existing customer 360 data model in Informatica MDM?

                     We can extend the customer 360 data model by various actions such as 

                               1) Changing the physical schema 

                               2) Adding needed columns to an existing table 

                              3) Adding for updating values for existing columns 

                  Following are the steps we need to perform to extend the data model.

                         Step 1 : Compare existing data model with business requirement and perform gap                                                   analysis 

                         Step 2 : Prepare documentation that will provide a list of tables and columns needed to                                        add

                         Step 3 : Take a backup of an existing schema 

                         Step 4 : Review guidelines and standards for extending the data model 

                         Step 5 : Add tables and columns as needed 






C) What are the Guidelines for extending the customer 360 data model? 

                   We can change the definition of tables or add a new table to the existing customer 360 data model. To perform these kinds of changes consider following guidelines 

                    1. Check if we can use the existing table 

                   2. Do not use a root base object to store organization or person information.

                   3. Do not define table names greater than 24 characters.

                   4. Do not delete existing columns

                   5. Do not delete existing base objects

                   6. Do not modify the data types of existing columns 

                   7. Do not modify the physical name of existing base objects. 

                   8. It is ok to modify the display name of existing base object tables or columns.

                   9. Do not decrease the length of an existing column.

                  10. Prefix the names of the new base object tables to distinguish the table from the existing tables.

                   11. For newly added column in the existing table-use prefix name of the column as x_


D) What are the guidelines for adding a new base object in the customer 360 data model? 

                  We can add root or child base objects, lookup base objects or relationship base objects. For adding new base objects we need to consider the following guidelines.

                 1. Child base object with one-to-many relationships- Add a Party Role foreign key in the table to relate the table to the Party Role table.

                 2. Child base object with many - to -many relationships- Use the relationship base object to relate the table to the Party Role table.

                 3. Use lookup Indicator as TRUE for the lookup table.


               Learn more about Informatica MDM here -

          



Tuesday, January 25, 2022

What is RANK function in Oracle database ?

               Are you looking for an article on the Rank function in the Oracle database? Are you also interested in knowing how to use the RANK function in SQL? If so, then you reached the right place. In this article, we will learn the RANK function in detail Let's start.


A) What is the RANK function?

              The RANK is an analytic function in oracle we use the RANK function to get the rank of a value in a group of values. The RANK  function can be used both as an aggregate and as an analytic function.






B) Using RANK function as an aggregate function 

             We need to use the following syntax in order to use the RANK function as an aggregate function 

             RANK (Expression_1 , Expression _2 .......Expression_n)

                           WITHIN GROUP

                          (ORDER BY Expression_1 , Expression_2......Expression_n)

             In the above syntax, Expression _1 , Expression_2 are used to determine the unique row in the group.

 





C) Using RANK function as an Analytic function 

              We need to use the following syntax in order to use RANK function as Analytic function -

              RANK ( ) OVER ( [ query - partition _clause ]

                                             ORDER BY clause )

             In above syntax -

            Order By clause - is an optional parameter and is used to order the data within each group.

            query-partition_clause - it is an optional parameter and is used to partition results set into groups.


D) DENSE_RANK in oracle 

               The DENSE_RANK in oracle determines the rank of a row in an ordered group of rows and returns rank as Number Rank values are not skipped in the event of ties. If values are the same then the same rank number is given.


                  Learn more about oracle here - 



Sunday, January 23, 2022

What Account Identifier in Snowflake ?

              Are you looking for an article about what is Account Identifier in Snowflake is? Are you also interested in knowing what is the format for Account Identifier? If so, then you reached the right place. In this article, we will also learn about Organization names and Account names.


A) What is an Account Identifier in Snowflake?

            The unique identifier which uniquely identifies the Snowflake account within a business entity and throughout the global network of snowflake is called Account Identifier.

            Here the global network of Snowflake comprises of supported cloud regions and cloud platforms.






B) What are the uses of Account Identifier?

              Following are important use cases where Account Identifier plays a vital role -

           1) Account identifier is used in URLs for accessing the Snowflake web interface.

           2) Account identifier is also used for connecting to Snowflake using drivers , snowSQL,                               connectors, and other clients. 

          3) It is also used in 3rd party applications which are part of the snowflake ecosystem.

          4) Account identifies is required for secure Data sharing, Database replications, and Failover/failback features.

          5) It is also used in interactions with external systems and securing snowflake internal operations.


C) How to identify Snowflake Account? 

             We can identify snowflake accounts using two ways -

          1) Using given name in Organization

          2)  Using snowflake assigned locator 

        for identifying accounts using names in the organization, the ORGADMIN role must be created.


D) Identifying Account using Name in Organization

            An organization is the first-class snowflake object and it is linked to the accounts owned by the business entity. The organization provides capabilities to administrators i.e users with ORGADMIN roles to create, view, and manage all accounts across different regions and cloud platforms.

          Important points : 

             1) Account name must be unique within the organization.

            2) Account name is not unique across organizations

            3) Account names with underscores also have dashed versions.   

     Account name as Account identifier format -

            1) <organization _name > - <account _name>

            2) <organization _name> _ <Account_name>

            3) <organization_name> . <Account_name>

    Let's understand more about organization Name and Account Name -

a) Organization Name: It is the name chosen by the customer 

        * Organization name must be unique across all snowflake organizations.

        * It can contain uppercase letters 

        * It can contain letters 

        * It should not contain underscore or any other special characters 

       * The organization name can be changed but has more complications.

b) Account Name: It is the name created by the customer.

       * Account Name must be unique in an organization

       * Account Name is not unique across snowflake organizations.






E) Identifying Account using Account locator in Region 

             The account locator is an identifier snowflake assigns at the time of account creation.

             Customers can provide specific value to the account locater if it is created through a service representative else it will generate with random strings.

            As each snowflake account is hosted on cloud platform in specific region , the account locator requires region id and cloud platform provider details in order to identify account using Account locator 

           Format using Account locator is 

        1) <account _locator> . <region_id>      or 

       2) <account_locator> . <region_id> . <cloud>


       Learn more about snowflake here 



                       

  






















































/

What are the features of Informatica Intelligent Data Management Cloud (IDMC)?

 Are you looking for the details Informatica Intelligent Data Management Cloud (IDMC)? Earlier it is called Informatica Intelligent Cloud Se...