Data Warehouse General Interview Questions
Questions Answers Views Company eMail

Explain Process flow in data warehouse??

BirlaSoft,

1 4496

if source contain 10records how you identify header and footer

Polaris,

2 5982

How to answer the question how many fakt table in your datawarehouse and what size it have?

Cap Gemini,

3 7297

Which one among Star and snowflake schemas will occupy more space?

Barclays,

1 7632

Why joiner transformation does not allow the aggregator transformation and expression transformation to join

2 9048

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1538

how to find unique records in informatica level

IBM,

1 2940

what is difference between scd2 and scd3

3 8249

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

IBM,

1519

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

1877

Define Data Warehousing?

Wipro,

721

What is Operational Data Store?

Informatica,

569

What are diagrams?

InfoAxon Technologies,

599

what are relationships?

InfoAxon Technologies,

582

what are the different views that are considered when building an object-oriented software system?

InfoAxon Technologies,

595


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How can we load the time dimension?

675


Whether dimension table can have numeric value?

580


Explain what are fact, dimension, and measure?

533


What is the difference between star and snowflake schemas?

575


What is data stream and data adaopter?

581






How to add a number to a macro variable?

529


What are the different problems that ?Data mining? can solve?

2319


Difference between e-r modeling and dimentional modeling?

473


what is parallel query?

1605


What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

539


Define Data Warehousing?

721


Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

510


How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

525


What are Non-additive facts?

637


Explain multivalued dependency?

548