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

Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..

2 7731

how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......

TCS, Tech Mahindra,

2 6887

What are the advantages and disadvantages of using Transformer cube?

TCS,

1 5497

how will optimiz the performance of sql in FM ?

Infosys,

2 7992

how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....

3 8291

What is the difference between Bitmap and Btree index?

Mind Tree,

3 20010

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 9629

How to delete duplicate record in Informatica?

7 30385

I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

IBM, KKL, Reliance,

2074

Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)

AIG, IBM,

7 13922

What is the difference between view and materialised view?

6 14450

what are methods to identify duplicate observations?

HCL,

5 11232

What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?

1 5646

How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?

4 8413

How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.

3 8131

Un-Answered Questions { Data Warehouse }

What is transformation metric in microstrategy?

1013

How will you execute direct sql in obiee?

916

Explain vproc in teradata?

1001

What is the use of datastage designer?

1154

Why do you get spool space errors? How do trouble-shoot them?

1055

Name the types of transformation?

954

What is the roundrobin collector?

1099

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1040

What is difference between content store and content manager?

978

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5122

What is the need of an ETL tool?

1094

How we can scale Reshift database?

What is clusterservices in obiee ? Why its used?

923

I have a few records just I want to store data in to targets cycling way how?

2363

What is the use of transformation?

998

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