DataStage Tips

DataStage tips is now active on datastagetipsntricks.blogspot.com

  • Home

How to eliminate duplicate rows?

Should we use user defined variables to store credentials like database username and password? Does DataStage keep the information secure when specified inside user defined variables?

How to rebuild the repository in DataStage?

What do you understand by "Lightweight" stages?

Which sort option you would use if the order of the non-key columns are needs to be maintained?

What are the differences between sorting on a link and Sort stage?

What is Orchestrate Schema Definitions and why one should use it?

Which stage would you use to rename/drop a column when you have a choice between a transformer and copy stage?

What character would DataStage use to pad when a variable length string is converted to fixed length string?

How would you decide between Lookup or Join while designing a job, if required?

What are the benefit of modular development in DataStage?

Stage Variables:

Buffering:

Does job read or access configuration file during the execution?

To get the maximum performance from job:

Point to remember while partitioning the data:

List 10 best practice points with regards to DataStage jobs?

List down 10 most important best practices regarding DataStage jobs.

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