If you're looking for DataStage Interview Questions & Answers for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research DataStage has a market share of about 3.9%. So, You still have opportunity to move ahead in your career in DataStage Development. Mindmajix offers Advanced DataStage Interview Questions 2018 that helps you in cracking your interview & acquire dream career as DataStage Developer.
Are you interested in taking up for DataStage Certification Training? Enroll for Free Demo on DataStage Training!
Q. 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.
Q. 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.
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.
Q. 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.
To import the DS jobs, dsimport.exe is used and to export the DS jobs, dsexport.exe is used.
Q. 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.
In Datastage 7.5 many new stages are added for more robustness and smooth performance, such as Procedure Stage, Command Stage, Generate Report etc.
Q. 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’.
The truncated data error can be fixed by using ENVIRONMENT VARIABLE ‘ IMPORT_REJECT_STRING_FIELD_OVERRUN’.
Q. 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.
Merge means to join two or more tables. The two tables are joined on the basis of Primary key columns in both the tables.
Q. 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.
As the name implies, data files contains the data and the descriptor file contains the description/information about the data in the data files.
Q. 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.
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.
Q. 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.
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.
Q. 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.
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.
For More information visit Mindmajix
Author
Lianamelissa is Research Analyst at Mindmajix. A techno freak who likes to explore different technologies. Likes to follow the technology trends in market and write about them.
No comments:
Post a Comment