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

Suppose we want to display zero when null values coming to report how can we do that?

865

Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

853

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

918

How to test report in reportnet?

956

What are aggregate transformation?

989

Tell me what is degree of a relation?

935

How to create prompts in report net?

939

What is the difference between power center and power mart?

965

What is the difference between filter and lookup transformation?

1022

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

904

In document how to create metrics?

938

Is union transormation is active transformation?

920

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

1128

How to import vsam files from source to target. Do we need a special plugin?

893

What is edw?

1116

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is a full backup?

906

What is the difference between junk dimension and degenerated dimension?

1027

What is degenerate dimension table?

944

What are situations where snowflake schema is better than star schema when the opposite is true?

931

What are the differences between datamart vs. Reporting cube?

1032

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2057

How to eliminate duplicate rows from flat file?

882

What are vaious etl tools in the market?

938

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

968

How can you set the session management?

1051

Is union transormation is active transformation?

920

Explain what are fact, dimension, and measure?

933

How to improve session performance in aggregator transformation?

935

What are the approaches used by optimizer during execution plan?

837

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

903

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