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

Explain usage analysis in datastage?

1226

What is size of a transaction and an array means in a datastage?

1370

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

1340

Why we use surrogate key?

1308

Define oconv () and iconv () functions in datastage?

1471

Name the third party tools that can be used in datastage?

1146

Define ds designer?

1330

Differentiate between odbc and drs stage?

1106

How do you find the number of rows in a sequential file?

1 3834

Why do we use link partitioner and link collector in datastage?

1193

How can one find bugs in job sequence?

1499

Differentiate between operational datastage (ods) and data warehouse?

1234

Differentiate between datastage and datastage tx?

1117

Why does microstrategy object manager search for object dependencies?

1015

What is level metrics in microstrategy?

1121

Un-Answered Questions { Data Warehouse }

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

2072

What are the steps to create a data model?

1109

What is a mapping, session, worklet, workflow, mapplet?

1055

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1153

What is the data type of the surrogate key?

1077

What is mean by aggregate aware?

1163

how are numeric and character missing values represented internally? : Sas programming

1202

i have one file i saved in csv how can i take these file into framework manager

2128

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2119

Explain the different types of views used in cognos.

984

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

2425

What could be a data source system?

1098

What is model?

1035

What are the five ways to do a table lookup in sas? : sas-grid-administration

1120

Explain target update override in informatica

1190

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