This blog is intended for Informatica PowerCenter, performance tuning etc.
Owner: sarmadrk
Listed in: Computers
Language: English
Tags: Informatica, PowerCenter, Lookup, Radhakrishna Sarma, Performance
Site Statistics
Unique Visitors Today:
0
Page Views Today:
0
Unique Visitors this Week:
0
Page Views this Week:
0
Unique Visitors this Month:
0
Page Views this Month:
0
Total Unique Visitors:
1
Total Page Views:
1
Total Hits Out:
118
Latest Blog Posts for Radhakrishna Sarma
- Dynamically generate parameter filesI've seen this in many places, but just want to tell you the way I have been doing it for few years now. I will take the context in a bit more detailed manner to make every one understand it.1. PowerCenter objects – Introduction:• A repository is...
- Designing the mapping/workflow efficiently - part IIIn few of my other blog articles, I've been mentioning about the push down optimization. In simple terms, try to push as much processing as possible into the database source or target based on the necessity. I will explain few instances where we can...
- Database Indexing for the Lookup SQL - A mython Jan 5, 2009I have seen people suggesting an index to improve the performance of any SQL. This suggestion is incorrect - many times. Specially when talking about indexing the condition port columns of Lookup SQL, it is far more "incorrect".Before explaining why...
- Designing the mapping/workflow efficiently - part Ion Jan 2, 2009I wanted to write some useful design tips for a mapping and workflow to increase the performance. As PowerCenter is a wide ocean and there can't be any exhaustive list of best practices. To address this, I want to add to this list in phases and that...
- Why do you restrict developer?on Dec 30, 2008I've been seeing some strange requests from developers these days. Here are few examples."I have a relational source and I want to take data for a column whose value is like '%XYZ%'. I want to accomplish this without SQL override on Source Qualifier"...
- Performance of workflow - Most feared, but the easiestWith the newer and newer versions of PowerCenter, there is added flexibility for the developer to build better-performing workflows. Though performance tuning has been the most feared part of development, it is the easiest, if the intricacies are kno...
- FTP Connection object - Gain platform independenceIf you have any files to be read as source from Windows server when your PowerCenter server is hosted on UNIX/LINUX, then makes use of FTP users on the Windows server and use File Reader with FTP Connection object. This connection object can be added...
- Avoid sequence generatorI would always advice you to avoid sequence generator while populating an ID column in the relational target table. I suggest you rather create a sequence on the target database and enable the trigger on that table to fetch the value from the databas...
- "This" and "That" of Pre/Post Session command tasksIt is a very good practice to email the success or failure status of a task, once it is done. In the same way, when a business requirement drives, make use of the Post Session Success and Failure email for proper communication. The built-in feature o...
- Never leave it a mystery - Multiple sources for one SQWhen you have different table joins in the source-qualifier, it is a bad practice to include the table in the SQL and not make it visible in the mapping, Though PowerCenter works fine without the source defined in Source Analyzer, it is a good practi...
Loading Comments...
Comments
{ds_PageTotalItemCount} commentcomments
{pvComments::date}
{pvComments::comment}