DataStage Tips
DataStage tips is now active on datastagetipsntricks.blogspot.com
Home
How to practice DataStage at home?
Handling not null reference data while using Lookup stage
Tip of the day - Using DataStage Row Generator with parameters
Tips - How to prepare for DataStage interview Part 2
Tips - How to prepare for DataStage interview Part 1
Is transformer a compiled component, TRUE or FALSE?
explain the null mapping between source and target columns?
What is range partition?
When sort merge is used, will it keep the order of the non key columns?
Sort merge does not perform sort but it specifies the order of the the rows that are being read from different partitions using the keys defined. TRUE or FALSE?
How to identify first and last row in a group in DataStage?
What is scratch area in DataStage?
Datasets
Stage Variables:
Buffering:
Performance of the job can be improved if:
Sort operations:
Parallelism is not always good:
To get the maximum performance from job:
Point to remember while partitioning the data:
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?