27 DataStage interview questions and answers


DataStage interview questions and answers

1. What is DataStage?
2.What are the differences between Datastage and Informatica?
3.What are the components of DataStage?
4.What is a merge in DataStage?
5.What are system variables and sequencers in DataStage
6.What is the difference between operational data stage (ODS) and data warehouse?
7.How do you generate Sequence number in Datastage?
8.Purpose of Pivot Stage and types of containers in DataStage
9.What can we do with DataStage Director?
10.Difference between data warehousing and OLAP
11.Entity, Attribute and Relationship in DataStage
12.What is a folder? Difference types of stages
13.How can we improve performance of Data Stage jobs? - DataStage
14.Command line functions that import and export the DataStage Jobs
15.Difference between ‘Validated Ok’ and ‘Compiled’ in Data Stage
16.How to implement complex jobs in Data Stage?
17.What are Stage variables and constants? - DataStage
18.Difference between Sequential File and Data Set - DataStage
19.How to perform incremental load in DataStage?
20.Importance of surrogate key in Data warehousing
21.What are the types of hashed files in Data Stage?
22.What is DS Administrator used for? - DataStage
23.What is the flow of loading data into fact & dimensional tables? - DataStage
24.What are the types of containers and how to create them? - DataStage
25.Difference between In Process and Inter Process - DataStage
26.Difference between server jobs & parallel jobs - DataStage
27.Functionalities of Link Partitioner and Link Collector - DataStage

Write your comment - Share Knowledge and Experience


Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring