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 are the errors u have faced in creating reports in business objects and explain some?

TCS,

3 10252

what are the documentations u r created?

Wipro,

2 6759

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

TCS,

7 13888

'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.

1 4624

I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?

3 8866

1.WHAT IS DATA MART ?

HCL,

5 10965

2.What is staging area ?

HCL, IBM, iFlex, TCS,

4 12812

3.What is fact less fact ?

Accenture, HCL, TCS,

9 14724

4.Explain Snowflkeschema ?

EDS, HCL, IBM, iFlex, TCS,

6 11655

5.Explain ODS ?

HCL,

3 9153

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2589

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2536

what is tuning of business reports ?

Business Intelligence Analytics, Oracle, TCS,

5 12048

can I use “drop” statement in the utility “fload”?

Accenture, CTS, NTT Data,

2 17364

Can we load a Multi set table using MLOAD?

2 12460

Un-Answered Questions { Data Warehouse }

Write the program through which the records can be updated?

1055

------------- How to identify the Revenue Column in Report?

2464

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1939

Can we collect statistics on multiple columns?

1132

Explain how are the dimension tables designed?

1118

In BTEQ, how are the session-mode parameters being set?

1192

What is crass reference table?

1100

What is data partitioning?

1274

What is meant by LDAP users?

1294

What is the importance of having monitor service in cognos?

1104

how do u catch bad rows from OCI stage? And what CLI stands for?

2856

What is the functional & architectural differences between business objects and web intelligence reports?

2462

Why fact table is in normal form?

1313

What is etl process? How many steps etl contains?

1087

What are the different models used in cluster analysis?

1011

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