Search this site
Embedded Files
Skip to main content
Skip to navigation
ETL and Data Warehouse links
ETL Links
Contact Us
ASCII Chart
Data Modelling
ETL delta logic & de-normalization of data model
Pitfalls of type II dimension
Type II dimension: What is expiry date? Does it come from Source or is it ETL date?
DataStage
A sample Unix script to run Datastage jobs
Buffering in DataStage
Configuring the XML input stage
DataStage commands in Unix
DataStage Date and Time Manipulation
Datastage Environment Variables
Discussion on Join, Lookup and Merge stages in DataStage
How to expose your DataStage job as a web service
How to stop and clean your Datastage server
Interfacing SFDC using DataStage webservice and XML stages
Introduction to Datastage for Beginners
Reset all jobs
Running Unix commands in DataStage
Sorting and partitioning in DataStage jobs
Subversion on InfoSphere 8.5
The history of Datastage
The Lookup stage in DataStage
The Sort stage in detail
Understanding the datastage configuration file
Using Java stages in DataStage
Using the Datastage message handlers
Enable LOB references
DataStage - Microsoft SQL Server
Remove Milliseconds from DateTime
SQL Date formats
SQL Server DATETIME to TIMESTAMP
When reading database column DFLOAT into column SFLOAT, truncation, loss of precision or data corruption can occur.
Datastage parallel
Modify Stage
DataStage Server
oconv
IBM Redbooks
InfoSphere links
JBoss Wildfly
PostgreSQL on Wildfly - regular data source
PostgreSQL on Wildfly - XA datasource
Microsoft SQL Server
Find a column
Find data in a database
SQL date formatting
SQLCMD
Microsoft SQL Server to Oracle data type conversion
Microsoft Windows System
Microsoft Windows Environment Variables
Oracle
Case Statement
CURSOR FOR Loop
Decode Function
Grant/Revoke Privileges
IF-THEN-ELSE Statement
Instr Function
IS NOT NULL
Literals
NVL Function
Oracle Data Types
Oracle System Tables
Substr Function
To_Char Function
TO_DATE
Transactions
Commit
Lock table
Rollback
Set Transaction
Variable declaration
Oracle DATE to Datastage Timestamp
PostgreSQL
postgres copy database to another server
postgres memory tuning
postgres memory architecture
postgres performance notes
postgres benchmarking
pgStat
SQL
ANSI SQL - select percentage of rows
Unix / Linux
Find and delete files in Linux using find
find and execute multiple commands
XML related
XSLT: Splitting an XML File into Multiple Files with XSLT
ETL and Data Warehouse links
Oracle System Tables
Oracle/PLSQL: Oracle System Tables
Below is an alphabetical listing of the Oracle system tables that are commonly used.
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse