Datastage Interview Questions and Answers
Here you can find Datastage Interview Questions and Answers.
Why Datastage Interview Questions and Answers Required?
In this Datastage Interview Questions and Answers section you can learn and practice Datastage Interview Questions and Answers to improve your skills in order to face
technical inerview by IT companies. By Practicing these interview questions, you can easily crack any Datastage interview.
Where can I get Datastage Interview Questions and Answers?
AllIndiaExams provides you lots Datastage Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students,
freshers can download Datastage Interview Questions and Answers as PDF files and eBooks.
How to solve these Datastage Interview Questions and Answers?
You no need to worry, we have given lots of Datastage Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the
Datastage technical interview.
Datastage Interview Questions and Answers
Define Data Stage?
A data stage is basically a tool that is used to design, develop and execute various applications to fill multiple tables in data warehouse or data marts.
It is a program for Windows servers that extracts data from databases and change them into data warehouses.
It has become an essential part of IBM WebSphere Data Integration suite.
Datastage Interview Questions and Answers
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.
Datastage Interview Questions and Answers
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.
Datastage Interview Questions and Answers
What is the difference between Datastage 7.5 and 7.0?
In Datastage 7.5 many new stages are added for more robustness and smooth performance, such as Procedure Stage, Command Stage, Generate Report etc.
Datastage Interview Questions and Answers
In Datastage, how you can fix the truncated data error?
The truncated data error can be fixed by using ENVIRONMENT VARIABLE ‘ IMPORT_REJECT_STRING_FIELD_OVERRUN’.
Datastage Interview Questions and Answers
Define Merge?
Merge means to join two or more tables.
The two tables are joined on the basis of Primary key columns in both the tables.
Datastage Interview Questions and Answers
Differentiate between data file and descriptor file?
As the name implies, data files contains the data and the descriptor file contains the description/information about the data in the data files.
Datastage Interview Questions and Answers
Differentiate between datastage and informatica?
In datastage, there is a concept of partition, parallelism for node configuration.
While, there is no concept of partition and parallelism in informatica for node configuration.
Also, Informatica is more scalable than Datastage.
Datastage is more user-friendly as compared to Informatica.
Datastage Interview Questions and Answers
Define Routines and their types?
Routines are basically collection of functions that is defined by DS manager.
It can be called via transformer stage.
There are three types of routines such as, parallel routines, main frame routines and server routines.
Datastage Interview Questions and Answers
How can you write parallel routines in datastage PX?
We can write parallel routines in C or C++ compiler.
Such routines are also created in DS manager and can be called from transformer stage.
