little tips and tricks, which i stumbled upon randomly

Tuesday, October 22, 2013

Informatica 9.5.1 Hot Fix 2 Preinstallation Check list

Hi All; This is my Informatica 9.5.1 hot fix 2 preinstallation check list for IBM AIX. Download Informatica software 9.5.1 HF1 for AIX from my.informatica.com via Global Customer Support. Get the correct licence files from Global Customer support Install...

Tuesday, September 17, 2013

How to move binary (raw) data with Informatica Power Center

Although Power Center shows this as possible, unfortunately you can not move binary or raw columns from source to target normally. You can try relational writer or external loader result is same. Binary/Raw column will be null. It is impossible to convert...

Monday, July 29, 2013

Readable folder size command in SUN Solaris

1:46 AM By

to get folder size in readable format use du -sh *| sort -n     Click for IBM AIX comma...

Thursday, July 4, 2013

Find string in file Unix

find . -exec grep -l "search string" {}...

Tuesday, June 18, 2013

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 can add follwing features to Informatica Sybase IQ External loader To be able to load data directly from Informatica...

Wednesday, May 15, 2013

unix while loop in bash

Simple as is :) i=0;while [ $i -le 1 ]; do clear;ps -ef | grep java;sleep 3;do...

Wednesday, April 10, 2013

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 check list for IBM AIX. Download Informatica software 9.5.1 HF1 for AIX from my.informatica.com via Global Customer...

Friday, March 29, 2013

Sybase IQ equavalent for Oracle PL/SQl subtract dates

It'is realy unique and easy to substract dates in Oracle. If you select SELECT TO_DATE ('01/02/2013 11:07:16','DD/MM/YYYY HH24:MI:SS') - TO_DATE('01/02/2013 11:03:37','DD/MM/YYYY HH24:MI:SS') FROM DUAL; Result is: 0,00253472222222222 To achive same...

Monday, February 25, 2013

Developer'ın halleri

12:22 AM By

Orjinal İspanyolca  kaynak Live'da değişiklik yaparken  Google'da aramadan sorunun çözümünü bulunca Değişiklikleri kaydetmeden programı kapatınca Gece saat 3'te sorun çözmeye çalışırken Regular Expression ilk seferde...