Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

Difference between data warehousing and olap?

1041

What is the difference between operational data stage (ods) and data warehouse?

1175

What are the types of containers in datastage?

1143

Explain entity, attribute and relationship in datastage?

1042

Difference between in process and inter process?

1162

What are stage variables and constants?

1095

What are the components of datastage?

1063

What are the differences between datastage and informatica?

1111

Explain the importance of surrogate key in data warehousing?

1128

How to implement complex jobs in data stage?

1049

Difference between server jobs & parallel jobs?

1015

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1192

What are the functionalities of link collector?

1035

What is the purpose of pivot stage?

1096

What are the various kinds of the hash file?

1094

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Name the different types of Lookups in Datastage?

1214

What is the precedence of stage variables,derivations, and constraints?

1027

How to perform incremental load in datastage?

1125

What is ibm datastage flow designer?

1080

Differentiate between odbc and drs stage?

997

What is the difference between the local container and shared container?

1041

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1136

what is use of SDR function?

5126

how to delete one row in target dataset

3061

What are the types of hashed files in data stage

1057

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3075

What all are the different way to run a job?

1026

How we can covert server job to a parallel job?

1060

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1294

How you Implemented SCD Type 1 & Type 2 in your project?

4072

For More Un-Answered { Data Stage } Questions Click Here