Scribd Logo
Upload

Welcome to Scribd!

  • 19 views

    Name of Solution:: Please Rate This Solution and Share Your Feedback On Website

    Uploaded by

    shantanuma1
    This solution uses the Expression transformation with the Data Masking transformation to maintain relationships between columns when masking data. It masks key, date, number, and formatted fields. Download the workflow and source file. Import the workflow into the repository. Open the mapplet to see how it masks data while maintaining relationships using an expression. Configure and execute the workflow to generate a masked target file.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Name of Solution:: Please Rate This Solution and Share Your Feedback On Website

    Uploaded by

    shantanuma1
    19 views3 pages
    This solution uses the Expression transformation with the Data Masking transformation to maintain relationships between columns when masking data. It masks key, date, number, and formatted fields. Download the workflow and source file. Import the workflow into the repository. Open the mapplet to see how it masks data while maintaining relationships using an expression. Configure and execute the workflow to generate a masked target file.

    Original Description:

    Infa User guide

    Original Title

    Userguide_1941

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This solution uses the Expression transformation with the Data Masking transformation to maintain relationships between columns when masking data. It masks key, date, number, and formatted fields. Download the workflow and source file. Import the workflow into the repository. Open the mapplet to see how it masks data while maintaining relationships using an expression. Configure and execute the workflow to generate a masked target file.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    19 views3 pages

    Name of Solution:: Please Rate This Solution and Share Your Feedback On Website

    Uploaded by

    shantanuma1
    This solution uses the Expression transformation with the Data Masking transformation to maintain relationships between columns when masking data. It masks key, date, number, and formatted fields. Download the workflow and source file. Import the workflow into the repository. Open the mapplet to see how it masks data while maintaining relationships using an expression. Configure and execute the workflow to generate a masked target file.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 3

    Please rate this solution and share your feedback on Marketplace Website.

    Name of Solution:
    PowerCenter Data Masking with an Expression
    Business Requirement:
    Use the Expression transformation with the Data Masking transformation to maintain a
    relationship between two columns.
    Solution URL:
    https://community.informatica.com/solutions/1941
    Supported Versions:
    PowerCenter 9.1 and 9.5
    Description:
    Use the Data Masking transformation to change sensitive production data to realistic test
    data for non-production environments. The Data Masking transformation modifies source
    data based on masking rules that you configure for each column. Create masked data for
    software development, testing, training, and data mining. You can maintain data
    relationships in the masked data and maintain referential integrity between database tables.
    The following example shows how to use the Expression transformation with the Data
    Masking transformation to maintain a relationship between two columns after you mask one
    of the columns.
    This example includes the following types of masking:
    Key
    Date blurring
    Number blurring
    Mask formatting
    Download file contents:
    1. Workflow
    2. Source File
    3. Document




    Please rate this solution and share your feedback on Marketplace Website.
    Steps to implement the solution:
    1. Place source file to $PMSourceFileDir folder.
    2. Import workflow wf_Data_Masking_With_Expression.XML using Repository
    Manager. Select the appropriate folder from repository and resolve the conflicts by
    choosing suitable option.
    Note: The core functionality of this solution is present as a mapplet in
    wf_Data_Masking_With_Expression_With_Mapplet.XML. If you want to use this
    solution as a mapplet in any of your mappings, just copy the mapplet after importing
    the contents in the export file.
    3. Open each of the mapplet in PowerCenter Designer, observe the data masking
    transformation.




    Please rate this solution and share your feedback on Marketplace Website.
    4. Open the workflow in Workflow Manager. Assign the integration service in Workflow -
    > Edit -> Integration Service.
    5. Edit session and assign valid connection object for the source and target.
    6. For more details for importing object please visit our YouTube link.
    7. Execute the workflow and review the target file customer_accounts_test1.out
    YouTube Video on Importing and Configuring Workflows:
    http://www.youtube.com/playlist?list=PLLRreK2jjjgWBQ4NPfp0QWTxYDvlnEqSJ
    Other Useful links:
    Mapping Bundles
    Workflow Bundles
    Informatica Tools Bundles
    Informatica for Social Media Bundles
    Debugging Tools Bundles
    Visio Templates Bundles
    B2B Templates and Projects Bundles
    Data Quality Packs and Plans Bundles
    Script Bundles

    You might also like