1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is an ETL or ETT? And what are the different types?

 6909

how do u extract data from different data sources explain with an example?

 1765

what are the reporting tools and difference between them?

 1578

how do u automate Extraction process?

 1 3980

without using ETL tool can u prepare a Data warehousing and maintaining?

 3 7064

how do u identify the changed records in operational data?

QualTech,

2125

what is SMP AND MPP?

 8 61423

what are the facilities provided by data warehouse to analytical users?

 1658

what are the facilities provided by OLAP to analytical users?

 1 4048

what is HISTOGRAM? how to generate statistics?

 1 4164

how do u set the size of block buffer?

 1 3733

how do u implement unconn.stored proc. in a mapping?

 1 4131

if u can't find what you are looking for in lookup table, how do you handle?

 1 4611

why oracle is the best database for data warehousing?

HCL,

4 7418

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

 1666

Un-Answered Questions { Data Warehouse }

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2129

Explain what are the advantages data mining over traditional approaches?

666

Explain level extension?

570

How do you add default rules in the transformer?

642

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

587




What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3908

Explain the different types of views used in cognos.

500

What is database exceptions in teradata?

531

How many transformations can be used in mapplets.

1443

What is the different type of jobs in datastage?

558

what are the different types of fact structures?

530

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

523

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

474

Mention some common errors that are usually committed in sas programming.

576

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3305

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