tips and tricks

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

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

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

Although Power Center shows this as possible, unfortunately you can not move binary or raw columns from source to target normally. You can t...

Sybase IQ equavalent for Oracle wm_concat and SQL group_concat is LIST() function. This function takes 2 parameters column_name (mandot...

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

to get folder size in readable format use du -gs *| sort -n click for SUN Solaris command

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

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

Although it seem hard and complicated. Once you discovered correct connection string and driver name getting data out of Informatica file ar...