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

how can u load the data in time dimension?

3 12344

what is the diff b/w target load plan and cbl?

CTS, iGate,

3 27551

what is the use of macros&folders&herarchies in frameworkmanger?

1 4261

How to give a securites in object level&datalevel&pakege lavel in frame work manager?

1 3065

Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?

TCS,

5 14332

How do you test the performance of a report?

TCS,

3 9119

what is crystal reports?how to migrate them?

IBM,

2 6342

what are the roles & responsibilities of microstrategy developer?

Infosys,

13 42249

What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 16704

What is meant by ZABO and FC(full-client)?

2 12372

if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?

CTS, TCS,

3 10694

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1928

Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,

320 286283

wt is meant by repartioning in howmany ways it can be done.

2 9819

what is the difference between rollup aggregation and aggregation ?

1 5486

Un-Answered Questions { Data Warehouse }

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2123

Mention the difference between ‘macros’ and ‘prompt’?

1160

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4055

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2602

How do you verify a complicated sql?

1077

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

981

Write the program through which the records can be updated?

1014

How do you create surrogate key using ab initio?

1006

Can we change Dynamic to Static or Persistent cache? If so what happens?

2226

Explain the data types present in bo n wht happens if we implement view in the designer n report?

993

What is Operational Data Store?

1085

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

1007

Explain the difference between data ware house & data mart?

974

Explain the different types of views used in cognos.

961

What are the different types of parallelism used in abinitio?

1126

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