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 11159

how to run the batch using pmcmd command

Wipro,

2 14198

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 12583

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

IBM,

6 12591

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

2295

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

2370

what is Cognos Visualizer?

1 5988

what is Governor settings in cagnos?

5 33133

whis meant by Thumbnails on cagnos?

2 7231

tell me the creation of Snapshots?

2 5609

what is fantrap and chasmtrap ?

Tech Mahindra,

5 16419

why do we use crystal reports rather than webintelligence reports ?

CTS, Tech Mahindra,

7 17467

what is the difference between DSS and ODS ?

IBM, Satyam,

2 18899

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

TCS,

4 11338

what is dashboards? what is metrics?

TCS,

7 22274

Un-Answered Questions { Data Warehouse }

I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2728

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.

1380

Describe the ways in which you can create macro variables? : sas-macro

1078

what is data governance? : Sas-di

1037

Explain the use of aggregator cache file?

1267

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

972

Is multi insert ansi standard?

2220

How to handle multi value dimensions?

2304

EXL informatica Questions

1401

What is a pre-defined event and user-defined event?

1052

Explain the parallel data extension in teradata?

1110

What does proc print, and proc contents are used for?

1146

why use references rather than pointers in the public api, particularly for arguments which are modified?

1019

To save time, can many reports be run at the same time?

1052

What is a linked cube?

1013

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