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?

930

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?

903

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

972

How to test report in reportnet?

1013

What are aggregate transformation?

1041

Tell me what is degree of a relation?

998

How to create prompts in report net?

989

What is the difference between power center and power mart?

1025

What is the difference between filter and lookup transformation?

1109

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

963

In document how to create metrics?

994

Is union transormation is active transformation?

981

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

1241

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

936

What is edw?

1200

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is factless fact tables?

1212

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2051

What is Star Schema?

1112

What is the use of incremental aggregation? Explain me in brief with an example?

1024

Difference between cold fusion 5 and cold fusion mx 6?

996

What is a data profile?

980

Explain the difference between data ware house & data mart?

961

Explain why should you put your data warehouse on a different system than your oltp system?

932

Explain what are data marts?

1127

What are session timeout and application timeout?

1023

What are algorithms provided by Microsoft in SQL Server?

2061

What are the steps involved in creating dimensional modeling process?

1022

Explain is fact table?

937

Explain conformed fact?

975

Why should we use data ware housing and how can you extract data for analysis with example?

1001

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