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 5395

if source contain 10records how you identify header and footer

Polaris,

2 7004

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

Cap Gemini,

3 8583

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

Barclays,

1 8350

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

2 10106

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

1972

how to find unique records in informatica level

IBM,

1 3665

what is difference between scd2 and scd3

3 9768

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

IBM,

1955

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

2470

Define Data Warehousing?

Wipro,

1147

What is Operational Data Store?

Informatica,

1076

What are diagrams?

InfoAxon Technologies,

1042

what are relationships?

InfoAxon Technologies,

1048

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

InfoAxon Technologies,

1031

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

what are relationships?

1048

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

2129

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

996

Explain multivalued dependency?

991

What is pre-emptive and non-pre-emptive?

977

What is difference macros and prompts?

2307

What is conformed fact?

1094

What is degenerate dimension table?

1001

What are vaious etl tools in the market?

1004

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

910

How to generate the cubes in framework manager?

1041

Explain dimension table ?

983

Explain what is partitioning? What are the types of partitioning?

973

What are the advantages of query studio compared to report studio?

893

How to create prompts in report net?

989

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