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?

876

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?

867

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

938

How to test report in reportnet?

970

What are aggregate transformation?

1012

Tell me what is degree of a relation?

957

How to create prompts in report net?

955

What is the difference between power center and power mart?

985

What is the difference between filter and lookup transformation?

1054

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

923

In document how to create metrics?

955

Is union transormation is active transformation?

937

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

1161

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

911

What is edw?

1142

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

1052

What are aggregate tables and aggregate fact tables?

984

What is data analysis? Where it will be used?

943

Where we use surrogate key explain with example?

1076

How to create different types of templates?

949

Explain hybrid slowly changing dimension?

979

How can we run the graph?

1022

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

888

What are the key columns in Fact and dimension tables?

952

Explain what are the steps to build the data warehouse?

910

what are the all possible features supported modify stage?

2094

What is is a star schema?

1100

Explain dimensional modelling?

933

Explain what are components of reportnet?

927

Explain er diagram?

953

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