Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

Explain Process flow in data warehouse??

BirlaSoft,

1 5402

if source contain 10records how you identify header and footer

Polaris,

2 7011

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

Cap Gemini,

3 8593

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

Barclays,

1 8354

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

2 10115

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

1978

how to find unique records in informatica level

IBM,

1 3671

what is difference between scd2 and scd3

3 9782

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

IBM,

1959

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

2471

Define Data Warehousing?

Wipro,

1155

What is Operational Data Store?

Informatica,

1079

What are diagrams?

InfoAxon Technologies,

1047

what are relationships?

InfoAxon Technologies,

1054

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

InfoAxon Technologies,

1036

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is a full backup?

973

Explain about core dimension, balanced dimension, and dirty dimension?

1012

Explain what are the modules in power mart?

1052

Can we start and stop single session in concurent bstch?

948

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1078

What is the differences between star and snowflake schemas?

1071

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

2837

What is a relationship?

999

how much memory space occupied real time project (roughly)?

2228

Explain what are the various file formats involved in reportnet?

947

What are components of report studio?

1059

What is batch processing?

1038

Explain what is power center repository?

1010

What are the differences between datamart vs. Reporting cube?

1102

Difference between cold fusion 5 and cold fusion mx 6?

999

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