Informatica Network : 2013 : June Skip navigation
2013

KB Articles

 

  1. HOW TO: Convert XML / Text files to PDF using B2B Data Transformation (128387)
  2. ERROR: "java.lang.NoClassDefFoundError: Could not initialize class" when PowerCenter workflow control response is invoked (139904)
  3. HOW TO: Configure the keystore with certificates from a CA like Verisign, Thawte (16553)
  4. HOW TO: Add user-specified hints to the SELECT clause of 'copy to staging' and 'copy to destination' insert statements in Data Archive for Oracle (140889)
  5. Knowledge Link: Informatica Data Explorer Installation and Configuration (109266)
  6. ERROR: "MyOtlStream::checkRowCountAsExpected() expected rows: 1 actual rows: 0" while running Applier process in IDR 9.5 (146136)
  7. "[ICMD_10033] Command [RestoreDomain] failed with error [RSVCSHARED_00021] Internal error. Failed to get a repository connection unique ID for the following reason: ['host:host']" while running RestoreDomain  (123464) 
  8. "JSDK_42001: [ERROR] Cannot get object class for : dvo/infact/PivotPluginImpl" when running a Data Validation Option test in PowerCenter (118967)
  9. Unable to create contents for the "Human Task" database in Informatica 9.5.1 HotFix1 (148995)
  10. FAQ: What is the Informatica FastClone Server? (145946)
  11. HOW TO: Run the CSM Client for IIR (123709)
  12. ERROR: "Cannot create the connection to the PowerCenter repository. Verify that the user account has permission to access the repository and restart the PowerCenter Repository Service" when importing connection in TDM 9.5.1 (148103)
  13. Informatica MDM Performance Foundation Guide (146176)
  14. Knowledge Link: Troubleshooting Guides for Metadata Manager (108405)
  15. HOW TO: Configure PowerExchange for JMS with IBM WebSphere MQ (113581)
  16. ERROR: "WRT_8165 TIMEOUT BASED COMMIT POINT" in session log in PowerCenter (138428)
  17. DB2 z/OS Change Data Capture data integrity and  stabilty issue introduced by DB2 V10 support (148595)
  18. HOW TO: Configure Reporting and Dashboard Service on an Existing Database User (146036)
  19. HOW TO: Generate Informatica Support Console license (119559)
  20. HOW TO: Interpret statistics in the UM Web Monitor (142353)

 

 

H2L

 

  1. Informatica 9.5.1 Supported Upgrade Paths
  2. Using PowerCenter to Process Flat Files in Real Time
  3. How to Achieve Greater Availability in Enterprise Data Integration Systems
  4. How to Use PowerCenter with Teradata to Load or Unload Data
  5. Running a Workflow on a PowerCenter Grid
  6. Techniques for Deployment from a Versioned Repository
  7. How to Use PowerCenter Web Services to Extend the Power of Data Integration
  8. Team-Based Development FAQs
  9. PowerCenter Repository Maintenance
  10. Calling a Web Service from a Web Service Consumer Transformation in Informatica Developer

 

Videos

 

  1. PowerCenter Express Overview - H2L video
  2. How to Use Business Glossary in Metadata Manager
  3. Parameterize Connections - H2L video
  4. Send an Email from a Workflow - H2L video
  5. MDM MultiDomain Best Practice: Effectively Managing HFs and EBF
  6. INFASupport Webinar recording *Introduction to Informatica 9.x Architecture*
  7. Steps to cleanup Tomcat cache to launch Administrator Console
  8. How to automate the repository and domain back up process for disaster recovery in PowerCenter
  9. Aggregate Data - H2L video
  10. How to import an XML source definition

    Dear Informatica Customers,

     

    We are delighted to announce the next of the Webinar series - Data Domain Discovery and Enterprise Discovery on 27th June 2013 from 8 AM to 9AM (PST) .

     

    Registrations for the Webinar are now open and the URL to register is:

     

    https://informatica.webex.com/informatica/j.php?ED=240470207&RG=1&UID=0&RT=MiM0 (Join as Participant)

     

    Alternatively,

     

     

    More details are available below:

     

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Topic - Data Domain Discovery and Enterprise Discovery

     

    About Data Domain Discovery

     

    You need to identify and understand the meaning of critical source data so that you can take measures to work effectively on it. Data domain discovery is the process of discovering the functional meaning of data in the data sources based on the semantics of data.

     

    Create a profile to perform data domain discovery and you can identify critical data characteristics within an enterprise. You can then apply further data management policies, such as data quality or data masking, to the data.

     

    For example, discover product codes or descriptions to analyze which data quality standardization or parsing rules you need to apply to make the data useful and trustworthy. Another example is to find sensitive customer data, such as credit card numbers, email IDs, and phone numbers. You may then want to mask this information to protect it.

     

    You can create and run a profile to perform data domain discovery in both Analyst and Developer tools. You can define a profile to perform data domain discovery based on the following rules:

    • Data rule- Finds columns with data that matches specific logic defined in the rule.
    • Column name rule- Finds columns that match column name logic defined in the rule.

     

    About Enterprise Discovery

     

    Enterprise discovery is the process of discovering column profile statistics, data domains, primary keys, and foreign keys in a large number of data sources. You can perform enterprise discovery across multiple connections or schemas.

     

    As an enterprise data analyst, you may want to discover important data characteristics across a large number of data sources. The requirements can include identification of relational data assets, column profile runs on the discovered data assets, discovery of critical data characteristics within the enterprise, primary keys, and candidate keys. You would also want to view the foreign key relationships that exist across the data sources so that you can derive a data model based on the discovered relationships.

     

    Enterprise discovery finds issues, patterns, trends, and critical data characteristics within information assets in your enterprise. You can choose both data sources that you imported into the Model repository and data sources from external relational connections. The data discovery process includes discovering column profile statistics, data domain analysis, data object structures including candidate keys, and data object relationships that include foreign keys.

     

    You run enterprise discovery in the Developer tool and it performs the following tasks on each data source:

     

    • Run a column profile.
    • Discover data domains.
    • Infer primary keys.

     

    After running column profiles, data domain discovery, and primary key profiles, the Developer tool runs a foreign key profile across all the data sources. After the Developer tool completes profiling and discovery tasks, it generates a consolidated results summary in both graphical and tabular formats.

     

    Below are the key areas that will be covered under this topic.

     

    • Introduction to Data Domain Discovery
    • Terms and Definitions
    • Data Domain Glossary
    • Data Domains and Data Domain      Groups
    • Data Domain Rules
    • Using Data Domain Discovery
    • Introduction to Enterprise      Discovery
    • Enterprise Discovery results      visualization
    • Export of Enterprise      Discovery results to Excel
    • DDL Generation
    • Q&A

     

    About the Speaker:

     

    Sunil Adinarayana is a Lead Subject Matter Expert in Data Quality with over 5 years of experience in helping customers on PowerCenter and Data Quality product lines. He has conducted various enablement sessions for different teams across the globe in Data Quality 9x and mentored many Support engineers on the Data Quality product line.

    -------------------------------------------------------------------------------------------------------------------------------------------------------------------

     

    If you have any issues registering for the Webinar, please feel free to contact Pattabhi at praman@informatica.com and he will be glad to help.

     

    InfaSupport Webinars are a monthly initiative from the Global Support Organization, where a Subject Matter expert will be presenting a webinar on a particular product.

     

    Please do let us know if you have any topics of interest and we shall try to get a webinar arranged on the same.

     

    Regards,

    MySupport Portal Team

    Filter Blog

    By date: By tag: