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?

Categories

  • Administration Questions
  • Best Practices
  • Business Analysis
  • Business Objects XI 3.1
  • CDC
  • CDC (DataMirror)
  • Config File
  • Data Warehouse
  • Dataset
  • DataStage 8.5
  • DataStage and Beyond
  • DataStage Functions
  • Date Operation
  • Environment Variables
  • Interview Questions
  • Job Export
  • Job Testing
  • Join Stage
  • Live Senario
  • Lookup Stage
  • MQ
  • Oracle Enterprise
  • RCP
  • Sequential File
  • Stage Variables
  • Tips
  • Top 100 Questions
  • Transformer Stage
  • Unix Commands
  • Unsolved Questions

Search This Blog

Other Categories

  • Business Analysis
  • Business Objects XI 3.1
  • Data Warehouse
  • DataStage and Beyond
  • Job Testing
  • Live Senario
  • MQ
© 2019 datastagetipsntricks.blogspot.com. All rights reserved | www.beingmoneysmart.com