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

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What are the primary usages of datastage tool?

1136

How many areas for files does datastage have?

1218

What are constraints and derivations?

1215

What are the types of containers and how to create them?

1034

What are the benefits of datastage?

1306

What are the different layers in the information server architecture?

1177

What are the functionalities of link partitioner and link collector?

1063

How do you reject records in a transformer?

1181

How many types of stage?

1231

what is ds administrator used for?

1223

What are transforms and what is the differenece between routines and transforms?

1110

What is the difference between round-robin partitioning and hash partitioning?

1035

What is fact? What are the types of facts?

1219

What is staging area referring to?

1216

How etl testing is different from database testing?

1128

Un-Answered Questions { Data Warehouse }

Mention sas system options to debug sas macros.

1243

Can anyone give me an exaple of realtime start script in the graph?

1119

How are models actually derived?

2065

How can we handle two sessions in informatica?

1098

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1472

Explain your project of banking domian.

1694

Write the different tools in the workflow manager?

1119

Mention some common errors that are usually committed in sas programming.

1107

design of staging area?

2080

how can you create zero observation dataset? : Sas programming

1203

How many types of views are there in a datastage director?

1340

What is meant by a Parsing Engine?

1237

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2053

What are snapshots?

1033

Can u access a repository created in previous version of Informatica?

1908

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