August 2015 ~ tips and tricks

Friday, August 7, 2015

How to find which process is holding file cache (disk space) in aix

5:16 AM By Ongun Demirler AIX, unix No comments

fuser -dV <path&...

How to move data out of Informatica File Archive to Hadoop using sqoop

1:21 AM By Ongun Demirler BigData, Informatica, Informatica ILM, Sqoop 1 comment

Although it seem hard and complicated. Once you discovered correct connection string and driver name getting data out of Informatica file archive with sqoop is pretty simple and straightforward. Unfortunately due to structure there is no way to specify...

Trendy List
- Informatica Certification - Informatica PowerCenter Data Integration 9.x:Developer Specialist Certification Preparation Guide
  
  After I got my Informatica PowerCenter Data Integration 9.x:Developer Specialist Certificate, I want to share my preparation experience with...
- UC4 status messages - AH_STATUS
  
  Unfortunately UC4 (Automic) software does not have any lookup table for ah_status values. These are the ah_status messages I stumbled upon...
- How to query Table - Column comments in Sybase IQ
  
  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 equavelent for while break structure
  
  Sybase IQ uses labes to exit loops . Instead of break you have to use exit label structure. Sample "while break" code: ...
- SYBASE IQ - Split coma seperated values in to rows
  
  To split delimiter separated values in to rows use sa_split_list function Usage: SELECT * FROM sa_split_list( 'Tee Shirt,Baseba...
- Informatica(9.5.1) Preinstallation Check list
  
  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 equivalent for Sybase IQ
  
  Oracle translate function has many great usages like Eliminating Double Quotes, Encryption/Decryption etc. I just wrote SybaseIQ version...
- UC4 Automic "Automatically deactivate when finished"
  
  You can use following SQL to query "Automatically deactivate when finished" status from UC4 repository. select OH_IDNR, OH_N...
- Informatica Sybase IQ external loader with client side load option
  
  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 style LTRIM / RTRIM for SYBASE IQ
  
  Oracle's LTRIM / RTRIM supports second parameter to remove other characters than blank. For example select LTRIM( 'My Textaaaa...

tips and tricks

Friday, August 7, 2015

How to find which process is holding file cache (disk space) in aix

Tuesday, August 4, 2015

How to move data out of Informatica File Archive to Hadoop using sqoop

Blog Archive

Labels

About Me

Total Pageviews

Trendy List