By Email
Informatica Way
Processing Multiple XML Files through Informatica – 1
Problem Statement: Data to be processed in Informatica were XML files in nature. The number of XML files to be processed was dynamic in nature. The need was also to ensure that the XML file name from which data is being processed is to be captured.
Resolution:
Option 1 – Using File list as part of Indirect [...]
Authored by Sivaram on March 3rd, 2010 under Informatica Way. Comments: none
Merge Rows as Columns / Transpose records
The Requirement: Converting rows to columns
Authored by Ganesan Thiyagarajan on September 14th, 2009 under Informatica Way. Comments: 4
Process Control / Audit of Workflows in Informatica
1. Process Control – Definition
Process control or Auditing of a workflow in an Informatica is capturing the job information like start time, end time, read count, insert count, update count and delete count. This information is captured and written into table as the workflow executes
Authored by Badri Narayanan on September 2nd, 2009 under Informatica Way. Comments: 6
Informatica Server Configuration for Greenplum and INFOBright database
Databases Greenplum [www.greenplum .com] and Infobright [http://www.infobright.com] are different databases from regular Oracle, SQL Server, they require certain special considerations in order to configure Informatica perform read/write on them.
Authored by Ganesan Thiyagarajan on July 15th, 2009 under Informatica Way. Comments: none
Informatica Upgrade Challenge –Default SQL Join for a Source Qualifier in 7x vs. 8x
Default SQL Query Generation for a Source Qualifier:
When relational sources are joined in one Source Qualifier transformation, the PowerCenter Server joins the tables based on the related keys in each table. This default join will be an equijoin like below
Source1.column_name = Source2.column_name
Authored by Senthil Kumar Aiyappan on May 11th, 2009 under Informatica Way. Comments: 1
Informatica and Oracle hints in SQL overrides
HINTS used in a SQL statement helps in sending instructions to the Oracle optimizer which would quicken the query processing time involved. Can we make use of these hints in SQL overrides within our Informatica mappings so as to improve a query performance?
Authored by Ganesan Thiyagarajan on April 22nd, 2009 under Informatica Way. Comments: 7
Informatica PowerCenter 8x Key Concepts – 6
Authored by Badri Narayanan on March 19th, 2009 under Informatica Way. Comments: 1
Informatica PowerCenter 8x Key Concepts – 5
5. Repository Service
As we already discussed about metadata repository, now we discuss a separate,multi-threaded process that retrieves, inserts and updates metadata in the repository database tables, it is Repository Service.
Authored by Badri Narayanan on January 16th, 2009 under Informatica Way. Comments: 2
Informatica PowerCenter 8x Key Concepts – 4
4. PowerCenter Client (contd)
Workflow Manager : In the Workflow Manager, we define a set of instructions called a workflow to execute mappings we build in the Designer. Generally, a workflow contains a session and any other task we may want to perform when we run a session. Tasks can include a session, email notification, or [...]
Authored by Badri Narayanan on December 9th, 2008 under Informatica Way. Comments: none
Informatica 8.6 Enhancements for Developers – 1
Informatica has released its latest version 8.6 covering all the hot fixes it released for the prior version 8.5 and including few new features. Since version 8, a Unified Admin Console has been designed for managing Integration and Repository services. These were discussed in earlier Blogs.