We generate Surrogate Key in DW environment to maintain history and we need a key other than Primary Key to uniquely identify the record. Example: If EMPNO is the key, we can keep only one record in target for the same Employee number and can’t maintain history, so we use Surrogate key as Primary [...]
From the category archives:
1. Problem Statement:
I am creating a XML file as an output . If my source is empty, is there a way to avoid the creation of an empty XML file?
Sample output Data with source data :
Case 1 : Empty Source – Creation of Minimal XML file
We have to set the following properties of an [...]
In an unconnected mapping, the Stored Procedure transformation does not connect to the pipeline.
The following figure shows a mapping with an Expression transformation that references the Stored Procedure transformation:
However, just like a connected mapping, we can apply the stored procedure to the flow of data through the mapping. In fact, we have greater flexibility since [...]
I attended a meeting organized for Informatica User Group recently in New York City. There was a good participation from in and around the city. The major commotion among the crowd was “Informatica Upgrade”. With our recent successful upgrade, people were eager to hear out the challenges faced and how we resolved it. I felt [...]
Informatica 9.1 doesn’t support Hyperion Planning Application connection, hence when we upgraded from 8.1 to 9.1, we had think of alternate options for loading data into Hyperion Planning. We determined two options:
1. Build Java code which makes use of Hyperion planning library files.
2. Have ODI (Oracle Data Integrator) which gets delivered with Hyperion platform
Bringing ODI [...]
This article explains about how to validate an XML document with XSD schema. The validation is performed by checking whether the XML document is a well-formed one by programmatically using Java packages. Using Java transformation in Infomatica PowerCenter 8.6 we are validating the XML.
We are creating the XML using expression and hard coding [...]
Informatica PowerCenter extended its functionality to support the Java language from the version of 8.0. Informatica PowerCenter provides a simple programming interface to implement transformation functionality with java programming language.
Informatica PowerCenter facilitates the developers/users to import the java packages and use them to achieve specific business rule which defined in the java package. Looping of [...]
With 9x wave from Informatica hitting the market big, our long plans for Informatica Upgrade were focused on to 9.1.0 HotFix 2 (a recent release) for the PowerCenter edition. The EOL(end of life) notice from Informatica to end their standard support on 8x also made our decision to focus on the latest and greatest version [...]
Power Center lets you control commit and roll back transactions based on a set of rows that pass through a Transaction Control transformation. A transaction is the set of rows bound by commit or roll back rows. You can define a transaction based on a varying number of input rows. You might want to define [...]
Parameter file is a text file that contains parameters and variables which can be referenced in Sessions and Workflows. Multiple Session and Workflows can share the same parameter file by logically grouping the Parameter file as mentioned below.
Each section is preceded by a heading that identifies the Integration Service, Integration Service process, Workflow, Worklet or [...]