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 7758

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

TCS, Tech Mahindra,

2 6907

What are the advantages and disadvantages of using Transformer cube?

TCS,

1 5517

how will optimiz the performance of sql in FM ?

Infosys,

2 8022

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 8318

What is the difference between Bitmap and Btree index?

Mind Tree,

3 20041

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

3 9662

How to delete duplicate record in Informatica?

7 30423

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,

2085

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 13980

What is the difference between view and materialised view?

6 14490

what are methods to identify duplicate observations?

HCL,

5 11276

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 5662

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 8450

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 8166

Un-Answered Questions { Data Warehouse }

Mention the validation tools used in SAS?

1197

Does AWS Redshift use SQL?

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1126

How can one identify whether mapping is correct or not without connecting session?

1464

What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

2158

Explain if a flat file cotains 1000 records how can I get first and last records only?

940

What is teradata and why it is used?

1116

how you migrate reports to cognos 8 from previous versions?

1057

What's the difference between timestamp (0) and timestamp (6)?

1208

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1633

Explain vproc in teradata?

1018

Do we need an etl tool?

1036

Mention some ways for improving performance of a graph?

1096

How many types of sorting methods are available in datastage?

1083

What are tpump utility limitations?

1136

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