Informatica World 2008
This article gives you an overview about day one at Informatica World 2008 in Las Vegas.
Analyzing SQL Overrides in Source Qualifier and Lookup
Sometimes you want to know if certain tables are listed in sql overrides of Source Qualifier or Lookup transformation. This helps you identifying dependencies. The query below will list folder, attribute type and sql override as output.
|
Listing 1: Analyzing SQL Overrides
Note:
SQL statement has been developed and tested with PowerCenter 7.1.3 repository (on Oracle). I recommend executing the query in PowerCenter Metadata Reporter (runs on DataAnalyzer).
Establishing Naming Convention
This article outlines how to establish a naming convention for Informatica PowerCenter.
Using Query Browser to perform multiple administrative actions
This article outlines how to perform multiple administrative actions within a versioned repository using Query Browser.
Using XSD Schema Wizard
This article gives guidance how to use XSD Schema Wizard in order to create an XSD Schema.
Using Parameter File Wizard
Using XML Wizard
This article gives guidance how to use XML Wizard in order to maintain the structure and content of XML documents.
Using Script File Wizard
This article gives guidance how to use Script File Wizard in order to maintain muliple pmrep commands and to run those commands sequentially.
Which algorithm should be used for verifying data integrity?
CheckSum Wizard supports a wide range of possibilities to calculate checksums of flat files. This article explains the different algorithms and concludes which algorithm the rights choice is for data integrety verification.
Using CheckSum Wizard
This article gives guidance how to use CheckSum Wizard in order to calculate checksums utilizing hash functions and output different checksum file formats.