It gets very challenging to do find and replace in UNIX as it doesn’t have means to undo changes in case mistakes. and we all are prone to do mistakes. So we (I mean myself also) generally tend to copy file in windows and after doing the changes we copy it back to UNIX. Seems tricky and interesting !!!!! it works well for me most of the time.

SQL tuning with real time project example, Learn whom to engage and how to engage. Understand what is in scope of a developer and what should falls in DBAs bucket. Most of time, I have seen that SQL tuning efforts goes waste because generally innocent developer doesn’t even aware that DBA has to be engaged. They feel that SQL Tuning is there task because DBA tells them that we don’t do development we just support DB system. This is not a truth.

A function is universally meant to wrap your code and help you to reuse it whenever you need it. PowerCenter is already rich with its system functions, however it also facilitate developer to develop a user defined function. Lets see how to develop user defined functions and the various advantages of it.

Unix Shell Scripting – 7 Steps i wish i knew when i started scripting – Introduction
This is an introductory guide for “Unix Shell Scripting Introduction” those who are quite comfortable with Unix commands and about to begin their travel towards scripting. Here I am trying to put up industry standard generic framework for shell scripting. Broadly, if your script is of high quality it will be written in these components. Believe me in so many places you will not see this, and please don’t blame me for that !!!!!!!

Code set is a generic terms used in healthcare industry. Each code in code sets denotes some description. HIPPA Code sets determined or decided by HIPPA (Health insurance portability and accountability act 1996). In simple words there is a regulatory body which regulates and define the code sets and associated meaning of those code sets. All the organizations operating in health care space have to ensure that they uses these code sets. So it enables them to share the data with other parties. No one can do business independently right, there are multiple parties involved in one business system. Having HIPPA code sets in place ensure fast data and un ambiguous data exchange.

XML is primarily a platform for storing, sharing of the data and it can be interpreted by wide range of computer applications or software. Today, Financial service industries like Banks and Forex, Brokerage houses prominently use XML as a data exchange solution considering the benefits that XML systems offer. And so majority of the data integration projects do generate and transfer their feed in XML form.

Active Lookup transformation has been evidently useful in power center from a long time. As we all aware that Power center 9 releases has upgraded lookup transformation to active, i.e it can return multiple values in the case of multiple matches. Lets see where is it useful and how could this be configured Consider a simple applicable area in Finance domain. In real time a person can have multiple accounts / credit cards and many add on cards connected to [...]

IDQ ( Informatica data quality ) is a super set of power center. To use IDQ you need to take a separate license. Another way around is that you can create a custom transformation in IDQ which in turn can be used in power center. Informatica data quality tool is different from profiling feature of Informatica. IDQ gives many in built features to streamline the data. As well it gives tremendous capability to business to review data , ensures greater business involvement which helps to achieve single truth of data.

Someone asked me today “Why is this session running so long?” hmmm seems like time to take up informatica session performance.
Well, a very common question that everyone working in Informatica would have come across– Why? Yet every session has its own parameters to look for and to consider like the process, hardware, and of-course the way Informatica mapping is coded and configured.

UNIX vi editor was the first biggest hurdle for me to get interest in UNIX, I was refraining to cultivate interest in UNIX initially. Just because I was not convinced to remember many commands to work in text editor in today’s time (like vi editor). Moreover because of UNIX server settings I was not even able to use FTP tools also like filezilla and WinScp.