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 what is the difference between stop and abort?

981

What are components of report studio?

966

What are the mapping paramaters and maping variables?

977

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

840

Explain what is the extension of file to save template?

915

What is the limit to the number of sources and targets you can have in a mapping?

1043

Explain the difference between filter and conditin?

910

Explain how to export mappings to the production environment?

918

Explain can report net connect multiple datasource at a time in report creation time?

872

Explain the versions of reportnet?

926

Explain what are the advantages of query studio compared to report studio?

968

Explain what is the limit to the number of sources and targets you can have in a mapping?

946

Explain what is the difference between powerplay transformer and power play reports?

1069

Explain what are the mapping paramaters and maping variables?

984

Explain the differences between normalizer and normalizer transformation?

952

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the difference between olap and oltp?

968

what are different storage options supported by oracle ?

2038

What function should we use to display the value entered or selected by a user in response to a prompt?

922

How to join 3 database like flat file, oracle, db2 in informatrica?

1128

Explain what is a view as it relates to system modeling?

924

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

988

What are the various tools? Explain name a few?

900

What is surrogate key? Where we use it?

932

Explain vldb?

987

Explain what is a cube in data warehousing concept?

930

Explain the difference between oltp and olap?

1055

What is the difference between connected and unconnected stored procedures?

988

In a star schema, are foreign key constraints between facts and dimensions neccessary?

932

What is normalization, first normal form, second normal form, third normal form?

911

Which columns go to the fact table and which columns go the dimension table?

921

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