tips and tricks

After I got my Informatica PowerCenter Data Integration 9.x:Developer Specialist Certificate, I want to share my preparation experience with...

Unfortunately UC4 (Automic) software does not have any lookup table for ah_status values. These are the ah_status messages I stumbled upon...

Table and cloumn comments can be queried from sys.systables and sys.syscolumns system views in Sybase IQ. Comments are stored in remarks c...

Sybase IQ uses labes to exit loops . Instead of break you have to use exit label structure. Sample "while break" code: ...

To split delimiter separated values in to rows use sa_split_list function Usage: SELECT * FROM sa_split_list( 'Tee Shirt,Baseba...

Hi All; *For Informacitca 9.5.1. Hot fix 2 preistallation check list please click here This is my Informatica 9.5.1 preinstallation chec...

Oracle translate function has many great usages like  Eliminating Double Quotes, Encryption/Decryption  etc. I just wrote SybaseIQ version...

You can use following SQL to query "Automatically deactivate when finished" status from UC4 repository. select OH_IDNR, OH_N...

In default to load data to Sybase IQ with Informatica external loader you have to transfer data to Sybase server. With following code you ...

Oracle's  LTRIM / RTRIM supports second parameter to remove other characters than blank. For example select LTRIM( 'My Textaaaa...