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 is the difference between macros and prompt?

IBM,

2 18450

What is the difference between drill down and drill through?

DELL, Deloitte, Systime,

10 62013

what is loop in frameworkmanager ?

Texas,

4 12334

what is drill down and slicing and dicing what are the difference between them?

IBM,

5 17240

What are differences between Reporter report and Explorer report?

2 7751

What is Cognos Powerhouse and what is it used for?

IBM, M Care,

2 14656

what was the actual purpose of portfolio in cognos ?

1 5122

What is IQD?What is contained in IQD?

ABC, IBM, Infosys,

3 11263

How you create IQD In ReportNet FrameWork?

IBM,

3 10692

How you drill from powerPLay to Impromptu?Explain all Steps?

2 7739

What are the Ways to Import Data into Catalong?

Cognos, IBM,

1 6052

what are the limitations of cognos reportnet?

IBM, Nestle, TCS,

11 23709

Explain the different stages in creating a report in cognos report net?

IBM,

3 12044

what is Cognos Visualizer and Cognos Scripting?

3 8862

what are versions of cognos from starting release to latest in the market?

DELL, IBM,

7 37198

Un-Answered Questions { Data Warehouse }

Enlist the functions performed by sas.

1128

Explain normalization?

1135

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

How to update or delete the rows in a target, which do not have key fields?

1178

What is the command used to find missing values?

1101

List out some of the primary characteristics of teradata.

1009

Enlist the advantages of informatica.

1068

What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2535

What is the scenario which compels informatica server to reject files?

1070

what techniques and/or procs do you use for tables? : Sas programming

1066

What are the components provided on node?

1042

Are you sensitive to code walk-throughs peer review or QC review?

3145

Explain the code page compatibility?

1071

How to create a permanent sas data set?

1239

What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

1373

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