Oracle doco
http://www.oracle.com/technetwork/indexes/documentation/index.html
Year: 2013
Analytic functions
http://www.orafaq.com/node/55 http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions004.htm
Parallel jobs – Oracle metadata
http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ds.parjob.adref.doc%2Ftopics%2Fc_deeadvrf_Oracle_Database_Tips.html
DataStage Grid Deployment Redbook
http://www.redbooks.ibm.com/redbooks/pdfs/sg247625.pdf
Sybase Table Fragmentation
http://www.whitesands.com/Products/frag_white.pdf
Password encryption in Sybase
Sybase supports password encryption. To configure datastage to use this: http://www-01.ibm.com/support/docview.wss?uid=swg1JR43532 A new Environment variable “APT_SYBASE_ENCRYPT_PASSWORD” has been introduced. Value of this Environment variable should be set to 1 to enable password encryption.
SQLLDR
http://docs.oracle.com/cd/B28359_01/server.111/b28319/ldr_modes.htm#i1008815
Information Server Manager: SubVersion Eclipse plug-in
http://www.dsxchange.com/viewtopic.php?t=138380&highlight=eclipse+plugin+subversion
IIS doco
http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp http://www-01.ibm.com/support/docview.wss?uid=swg27008803
Get DataStage job number
An easy way to find a job number is with DataStage Administrator. In DataStage Administrator, select a project on the Projects tab, then press the Command button. Enter the command: LIST DS_JOBS JOBNO WITH NAME = “your job name“ Press the Execute button, and …