DataStage Tips
DataStage tips is now active on datastagetipsntricks.blogspot.com
Home
How to perform upsert in DataStage?
How many processes will be created by a job where a sequential file, one OCI stage joined with join stage and result is being uploaded using a OCI stage?
How do you catch bad rows from OCI stage?
What is fast load in DataStage?
What is optimal arraysize for native Oracle stage in DataStage?
When a database native stage is in use, how the transaction control mechanism works?
Can you fire a DDL statement from database stage open command?
What is arraysize property of OCI stage?
What is the difference between conventional path and direct path with regards to Load method while using OCI stage?
Do you need Oracle ODBC driver to be installed on the server in order to connect to the Oracle database from DataStage?
How would you execute Oracle Database DDL commands from DataStage?
What is array size property of OCI stage? How this property can help improving the performance of a job?
Older Posts
Home
Subscribe to:
Posts (Atom)
Popular Questions
How to improve performance of jobs by maintaining different DataStage directories?
How to fetch just first and last record from DataStage sequential file?
How can we do the incremental loading in datastage?
What is the difference between Lookup, Join and Merge stage?
What is Orchestrate Schema Definitions and why one should use it?
