+91 90691 39140 | +1 253 214 3115 | info@hub4tech.com | hub4tech

Data Stage Interview Questions and Answers

1
Explain how a source file is populated?

We can populate a source file in many ways such as by creating a SQL query in Oracle, or by using row generator extract tool etc.

2
What types of Jobs you developed?
  • Server Job
  • Parallel Job
  • Sequencer Job
  • Container Job
3
Define Job control?

Job control can be best performed by using Job Control Language (JCL). This tool is used to execute multiple jobs simultaneously, without using any kind of loop.

4
What are the differences between Datastage and Informatica?
  • Data stage supports parallel processing
  • Links are treated as objects in Data Stage
  • Links are port to port connectivity in Informatica
  • The implementation of Slowly Changing Dimensions is easy in Informatica which are complex in Data Stage
  • Complete error handling is not supported by informatica, which is supported Datastage.
5
Name the command line functions to import and export the DS jobs?

To import the DS jobs, dsimport.exe is used and to export the DS jobs, dsexport.exe is used.

Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US