Wednesday, October 9, 2019 admin Comments(0)

1) What is Datastage? Design jobs for Extraction, Transformation and Loading( ETL). Ideal tool data integration projects such as data warehouses, data marts. Datastage Interview Question and Answers - Download as Word Doc .doc /. docx), PDF File .pdf), Text File .txt) or read online. Priya Menon.

Language:English, Spanish, Japanese
Genre:Fiction & Literature
Published (Last):16.07.2015
ePub File Size:28.84 MB
PDF File Size:16.61 MB
Distribution:Free* [*Register to download]
Uploaded by: ENRIQUE

Important and frequently asked Datastage interview questions with answers. PDF version also available for IBM Datastage questions and answers useful for. A data stage is basically a tool that is used to design, develop and Top 50 Datastage Interview Questions & Answers .. Download PDF. Frequently asked Datastage Interview Questions with detailed answers and examples. Tips and Tricks for cracking Datastage interview. Happy job hunting.

All these questions are frequently asked ones and better prepare all these before attending your Datastage interview. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition. You may consider reading these few questions and answers before attending. They may be of great help to you in the long run. What are the areas of application?

Interview questions pdf datastage

Home page Contact Us. Net DWH New. Datastage Interview Question and Answers. What is the difference between DataStage and Informatica? All Rights Reserved. Cognos Questions. BO Questions. Business Intelligence. Informatica - I. DWH Basic. A Job Container contains two unique stages.

The Container Input stage is used to pass data into the Container. The Container Output stage is used to pass data out of the Container. What are mainframe jobs?

DataStage Interview Questions And Answers

A Mainframe job is complied and run on the mainframe , Data Extracted by such jobs is then loaded into the datawarehouse. What are parallel jobs? How do you use procedure in datastage job? What is odbc stage? Used to represent a data source , an aggregation step , or target data table Server Job Only.

Hash file is just like indexed sequential file , this file internally indexed with a particular key value. Static Hash File. What is a stage variable?

In Datastage transformation , we can define some variable and define Value from source. What are constraints and derivations? We can create constraints and derivations with datastage variable.

How do you reject records in a transformer? Through datastage constraint we can reject record. Why do you need stage variables? What are data elements? A specification that describes the type of data in a column and how the data is converted.

What are routines? In Datastage routine is just like function , which we call in datastage job. Transforms is used to manipulate data within datastage job.

What a datastage macro? The available macros are concerned with ascertaining job status. A job control routine provides the means of controlling other jobs from the current job.

Data Stage Interview Questions & Answers

A set of one or more jobs can be validated, run ,reset , stopped , scheduled in much the same way as the current job can be. How many types of stage? There are three basic type of stage. All type of job have these stage.

Server jobs and parallel jobs can make use of these. Only job sequencer have these. Define the difference between active and Passive Stage? There are two kinds of stages: Passive stages define read and write access to data sources and repositories.

DataStage Interview Questions And Answers

Transformer Aggregator Sort plug-in What are the plugin stages used in your projects? The files are suitable for loading into the target database using the Oracle command sqlldr. What is Sort plugin? A mainframe processing stage that sorts input columns. What is Aggregate stage? A stage type that compute s totals or other functions of set of data. What is the hash file stage and Sequential file stage? A stage that extracts data or load data into database that contain hashed file.

Interview pdf datastage questions

What types of flat files you used. Sequential flat file with comma separated. What is the Job control code?

DataStage Interview Questions And Answers

These are compiled and run on the DataStage server in a similar way to server jobs , but support parallel processing on SMP,MPP and cluster systems How do you use procedure in datastage job?

A mainframe processing stage that sorts input columns What is Aggregate stage? Select Your Demo Date.