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

generate date / time dimension in informatica

Informatica,

1125

What are the tasks that source qualifier perform?

Informatica,

1105

Explain lookup transformation is active in informatica

Informatica,

1104

what are the Methods For Creating Reusable Transformations?

Informatica,

1171

how to load rows into fact table in data warehouse

Informatica,

1188

What is an active transformation?

Informatica,

1106

What are the main issues while working with flat files as source and as targets ?

Informatica,

1154

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

Informatica,

1 1864

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

Informatica,

1264

Define Data Warehousing?

Wipro,

1145

differentiate between view and materialized view?

IBM,

name the window by which you can create your own custom scripts?

IBM,

what is the role of skipcheck in tm1?

IBM,

define drill through?

IBM,

how we can generate cubes in cognos?

IBM,

Un-Answered Questions { Data Warehouse }

What is MAX CORE of a component?

1320

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1926

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2812

Why union transformation is an active transformation?

1047

What are the different operating system platforms in which we can use sas? : sas-grid-administration

1072

What are parallel querys and query hints?

2228

What olap capabilities do I have within a microstrategy report services document?

924

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2202

how to delete one row in target dataset

3122

what is the difference b/w the refresh and buffered data?

2342

What is an enterprise?

1039

What is conduct>it?

1114

Comment whether bottleneck is an error or not.

1156

What are the default statistics that proc means produce?

1045

Difference between informat and format?

1093

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