DataStage Tips

DataStage tips is now active on datastagetipsntricks.blogspot.com

  • Home

What is the difference between Merge, join and Lookup?

Can a Lookup stage have more than one reference links?

Lookup processing will not start until data for all reference links have been read into memory. True or False?

In how many phases a lookup runs?

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

What is spars lookup? When we should use spars lookup?

How much less data is "less" for Lookup stage to use?

What are the different types of lookup? When one should use sparse lookup in 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?

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