Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Archive 6.4.3
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Smart Partitioning
  9. SAP Application Retirement Entities
  10. Import Formats for Constraints
  11. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Back Next

Step 3. Create and Configure the Segmentation Group

Step 3. Create and Configure the Segmentation Group

Create and configure the segmentation group. To configure the segmentation group you must select the included tables, mark the driving tables, add constraints, apply business rules, and add dimension rules.
  1. In the Explorer pane, right-click on the application module you created in step 2.
  2. Click on
    New Entity
    .
    The
    Entity Wizard
     appears.
  3. Enter a name and optionally a description for the segmentation group.
  4. Click
    Finish
    .
    The new segmentation group appears under the application module.
  5. Click on the segmentation group you created.
  6. Click on the
    Tables
     tab.
  7. In the top pane, click on the green
    Add
     button and select a table to include in the segmentation group from the drop-down list of available tables.
  8. If the table has multiple aliases, add the table multiple times and select each alias for inclusion.
  9. If you want to register a table index or create a temporary index, select the table in the
    Tables
     pane.
  10. In the
    Optimization Indexes
     pane, enter an index name.
  11. Click in the
    Index Usage
     column and select whether the index will be used for default segment creation, non-default segment creation, or both.
  12. If the index is temporary, select the
    Temporary
     checkbox.
    The
    Index Columns
     window appears.
  13. Enter the columns you want to use for indexing.
  14. For temporary indexes, select the
    Unique
     checkbox if the index is unique.
  15. Click on the
    Driving Tables
     tab.
  16. Click on the green
    Add
     button and select a driving table from the drop-down list of available tables. Repeat for multiple driving tables.
  17. If you plan to use interim table processing to pre-process business rules for the segmentation group, select the
    Use Interim Processing
     checkbox and choose the primary key for the table.
  19. Click on the
    Constraints
     tab.
  20. In the
    Constraint
     field, select the type of constraint that exists for each listed child table and child alias table.
  21. Click on the
    Dimension Rules
     tab.
  22. Double-click in the
    Driving Table
     field. From the drop-down menu of available driving tables, select the driving table on which to associate the dimension.
  23. Double-click in the
    Dimension Name
     field. From the drop-down menu of available dimensions, select a dimension to associate with the segmentation group.
    The EDM populates the
    Data Type
     and
    Dimension Parameters
     fields based on the dimension you chose.
  24. In the
    Dimension Rule
     field, enter the WHERE or SELECT clause that implements the dimension rule.
    For example: ORDER_DATE BETWEEN :DATE_FROM AND :DATE_TO
  25. In the
    Dimension Rule Name
     field, give the dimension rule a name.
  26. Click on the
    Business Rules
     tab.
  27. In the
    Driving Table Name
     field, select the driving table on which to associate the business rule.
  28. In the
    Business Rule
     field, enter the WHERE clause that implements the business rule.
    For example: ORDER_STATUS = 'CLOSED'
  29. In the
    Business Rule Name
     field, give the business rule a name.
0 COMMENTS
We’d like to hear from you!