Q14) What is a dynamic array in DataStage?Īns: Dynamic arrays map the structure of DataStage file records to character string data. It is used to represent a data source, an aggregation step, or a target data table. Q12) State the types of server components.Īns: A stage that extracts data from or loads data into a Universe database using SQL. In Informatica, it is easy to implement Slowly Changing Dimensions which is a little bit complex in DataStage.ĭataStage doesn’t support complete error handling. Links are objects in the DataStage, but in Informatica, it’s a port to port connectivity. Q11) Differentiate between DataStage and Informatica.ĭataStage supports parallel processing which Informatica doesn’t.
Locales: Locales define the local formats for date, time, sorting order, etc. Maps: Maps defines the sets that can be utilized in a project. A table definition describing the structure of the table is known as metadata. Q8) Who are the DataStage clients or users?Īns: Data about data is known as metadata. Q7) At which location DataStage repository is stored?Īns: DataStage stores its repository in IBM Universe Database. Q6) State the difference between Server job and parallel jobĪns: Server Jobs work in a sequential way while parallel jobs work in a parallel fashion (Parallel Extender works on the principle of pipeline and partition) for I/O processing. Q5) What are the jobs available in DataStage? You can use it to convert your data and you can easily extend the functionality by defining your own transforms to use. It has a set of predefined transforms and functions. You can modify SQL SELECT statements used to extract dataĭataStage transforms data easily. You can view and modify the table definitions at any point during the design of your application. Handles all the metadata definitions required to define your data warehouse. It has four main components, namely:Įxtracts data from any number or types of database. Q3) What are the components of DataStage?Īns: DataStage has a number of client and server components. DataStage is an important part of the IBM WebSphere Data Integration Suite. 400 PUZZLES AND ANSWERS FOR INTERVIEW PDF CONVERTER SOFTWARE
It is software for windows servers that helps in data extraction from databases and modifies them into data warehouses. Let’s begin with IBM DataStage Interview questions and answers.Īns: DataStage is a tool developed by IBM that is used to design, develop, and execute different applications to fill the gap of multiple tables in data warehouses or data marts.
Scenario-based Data stage Interview Questions. Datastage Technical Interview Questions. Categories of Datastage Interview Questions
0 kommentar(er)
