Oracle table comparison
Using DBMS_COMPARISON package: http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_comparison.htm#CHDHEFFJ
Author: admin
Search Tortoise SVN repository from Windows
C:\>svn list -R <REPOSITORY_URL> | grep <FILE_PATTERN>
Datastage Redbooks
http://it.toolbox.com/blogs/infosphere/every-ibm-information-server-redbook-ranked-and-reviewed-57617
Oracle doco
http://www.oracle.com/technetwork/indexes/documentation/index.html
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