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?

926

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?

901

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

971

How to test report in reportnet?

1010

What are aggregate transformation?

1037

Tell me what is degree of a relation?

997

How to create prompts in report net?

989

What is the difference between power center and power mart?

1022

What is the difference between filter and lookup transformation?

1107

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

958

In document how to create metrics?

992

Is union transormation is active transformation?

975

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

1239

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

935

What is edw?

1196

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How we are using this function?

1118

What is the difference between dependent data warehouse and independent data warehouse?

1007

What are the other names given to data warehousing?

1094

What is meant by metadata in context of a data warehouse?

963

Explain er diagram?

991

What is freehand sql?

1045

Explain how to generate iqd file from framework manager?

946

What are components of report studio?

1055

What is your spectra photometer working principles?

982

What is the difference between connected and unconnected stored procedures?

1082

Explain the main difference between inmon and kimball philosophies of data warehousing?

969

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

1955

What is prompt types of prompts?use of prompts syntax of prompt?

1344

What do you mean by static and local variable?

963

What is surrogate key? Where we use it explain with example?

931

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