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 10124

what are the documentations u r created?

Wipro,

2 6643

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 13694

'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 4553

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 8742

1.WHAT IS DATA MART ?

HCL,

5 10768

2.What is staging area ?

HCL, IBM, iFlex, TCS,

4 12640

3.What is fact less fact ?

Accenture, HCL, TCS,

9 14428

4.Explain Snowflkeschema ?

EDS, HCL, IBM, iFlex, TCS,

6 11445

5.Explain ODS ?

HCL,

3 8980

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

2539

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

2488

what is tuning of business reports ?

Business Intelligence Analytics, Oracle, TCS,

5 11859

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

Accenture, CTS, NTT Data,

2 17233

Can we load a Multi set table using MLOAD?

2 12370

Un-Answered Questions { Data Warehouse }

Explain how a source file is populated?

1373

What is the reusable transformation?

1053

We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

1372

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

2106

What is a look-up?

1270

What is lookup transformation?

1046

how to generate the test data in sas without input data? : Sas-administrator

1141

What is fact table? Explain the different kinds of facts.

1080

permutations of mapplet

2513

what is Forward,Reverse and Re_engineering?

2261

Explain when we use aggregate awareness function in designer?

1032

Describe the main features of datastage?

1078

What is scd1 , scd2 , scd3?

1093

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4582

explain checkin and checkout?

1148

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