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

Column level security in report

4 11170

how to run the batch using pmcmd command

Wipro,

2 14207

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 12593

How many universe dfi you create if you have 2 years of experience in BO

IBM,

6 12609

how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

2298

How can we Maintain the Cube Security by Category level and Dimension level ?

2372

what is Cognos Visualizer?

1 5996

what is Governor settings in cagnos?

5 33147

whis meant by Thumbnails on cagnos?

2 7238

tell me the creation of Snapshots?

2 5613

what is fantrap and chasmtrap ?

Tech Mahindra,

5 16446

why do we use crystal reports rather than webintelligence reports ?

CTS, Tech Mahindra,

7 17495

what is the difference between DSS and ODS ?

IBM, Satyam,

2 18904

IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?

TCS,

4 11359

what is dashboards? what is metrics?

TCS,

7 22303

Un-Answered Questions { Data Warehouse }

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2190

What is called materialized view?

1086

Why update strategy and union transformations are active? Explain with examples.

1252

can u any challenge your project?

2046

What is decode in static cache?

1199

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1088

How can we improve the performance in datastage?

1117

Explain attribute role?

1106

What do you understand by SOA of Informatica?

1006

differentiate between two-tier, three-tier and four-tier connections.

1011

explain in detail about type 3?

1031

How will you enable or disable caching in the system level and table level?

905

what are 5 ways to perform a table lookup in sas? : Sas-administrator

1259

Can we configure two instances of CMS pointing to two different CMS system databases?

2046

How can you create a macro variable with in data step? : sas-macro

1056

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