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?

898

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

970

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?

988

What is the difference between power center and power mart?

1020

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)?

957

In document how to create metrics?

990

Is union transormation is active transformation?

974

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

1236

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 }

What are modeling tools available in the market?

977

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

1029

Where the cache files stored?

1012

ware house management system is used?

1009

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

970

What needs to be done when the database is shutdown?

1024

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1088

Explain what are data marts?

1120

Compare aggregates and data marts

2765

Explain degenerate dimension table?

1046

What is a hash cluster?

982

Explain what is real time data-warehousing?

1102

What is is a star schema?

1172

What is static and local variable?

1035

What are the different types of data warehousing?

957

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