Informatica World 2008

This article gives you an overview about day one at Informatica World 2008 in Las Vegas.

Read the rest of this entry »

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.

SELECT REP_ALL_MAPPINGS.SUBJECT_AREA, REP_ALL_MAPPINGS.MAPPING_NAME, REP_WIDGET_ATTR.ATTR_NAME, REP_WIDGET_ATTR.ATTR_VALUE
FROM REP_WIDGET_ATTR, REP_WIDGET_INST, REP_ALL_MAPPINGS
WHERE REP_WIDGET_ATTR.WIDGET_ID = REP_WIDGET_INST.WIDGET_ID
AND REP_WIDGET_INST.MAPPING_ID = REP_ALL_MAPPINGS.MAPPING_ID
AND REP_WIDGET_ATTR.WIDGET_TYPE IN (3,11)
AND REP_WIDGET_ATTR.ATTR_ID = 1
AND REP_WIDGET_ATTR.ATTR_VALUE LIKE ‘%’ || REPLACE(‘[ENTER_TABLE_HERE]’, ‘_’, ‘/_’) || ‘%’ ESCAPE ‘/’
ORDER BY REP_WIDGET_ATTR.WIDGET_TYPE ASC

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.

Read the rest of this entry »

Using Query Browser to perform multiple administrative actions

This article outlines how to perform multiple administrative actions within a versioned repository using Query Browser.

Read the rest of this entry »

Using XSD Schema Wizard

This article gives guidance how to use XSD Schema Wizard in order to create an XSD Schema.

Read the rest of this entry »

Using Parameter File Wizard

This article gives guidance how to use Parameter File Wizard in order to create a parameter file.

Read the rest of this entry »

Using XML Wizard

This article gives guidance how to use XML Wizard in order to maintain the structure and content of XML documents.

Read the rest of this entry »

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.

Read the rest of this entry »

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.

Read the rest of this entry »

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.

Read the rest of this entry »