Latest Blog Posts for Radhakrishna Sarma

• Dynamically generate parameter files
  on Apr 23, 2009 in Informatica PowerCenter Parameter file Dynamic files
  I'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 II
  on Apr 3, 2009 in Informatica Analytics Workflow performance Stored Procedure transformation PowerCenter Performance
  In 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 myth
  on Jan 5, 2009
  I 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 I
  on Jan 2, 2009
  I 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, 2008
  I'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 easiest
  on Dec 26, 2008 in Informatica Workflow performance PowerCenter SQL tuning
  With 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 independence
  on Dec 26, 2008 in Informatica PowerCenter FTP Connection objects
  If 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 generator
  on Dec 26, 2008 in Informatica PowerCenter Sequence Generator
  I 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 tasks
  on Dec 22, 2008 in Informatica PowerCenter Command tasks
  It 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 SQ
  on Nov 23, 2008 in Informatica PowerCenter Multiple relational sources
  When 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...

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment