PL/SQL Records
Kareem
Monday, February 11, 2013
What are records? Records are another type of datatypes which oracle allows to be defined as a placeholder. Records are composite dat...
Monday, February 11, 2013
PL/SQL Constants
Kareem
Monday, February 11, 2013
As the name implies a constant is a value used in a PL/SQL Block that remains unchanged throughout the program. A constant is a user-defi...
Sunday, February 10, 2013
Implementing Informatica Persistent Cache
Kareem
Sunday, February 10, 2013
You must have noticed that the "time" Informatica takes to build the lookup cache can be too much sometimes depending on the lo...
Saturday, February 9, 2013
Informatica – User Defined Functions
Kareem
Saturday, February 09, 2013
Informatica User Defined Functions are similar to Built-in Functions, where these functions need to be created once and execute mul...
Informatica Performance Improvement Tips
Kareem
Saturday, February 09, 2013
We often come across situations where Data Transformation Manager (DTM) takes more time to read from Source or when writing in to a Targe...
Informatica Development Best Practices – Mapping
Kareem
Saturday, February 09, 2013
The following are generally accepted “Best Practices” for Informatica PowerCenter ETL development and if implemented, can significantly im...
