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?

906

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

974

How to test report in reportnet?

1017

What are aggregate transformation?

1043

Tell me what is degree of a relation?

1002

How to create prompts in report net?

990

What is the difference between power center and power mart?

1026

What is the difference between filter and lookup transformation?

1114

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

964

In document how to create metrics?

996

Is union transormation is active transformation?

986

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

1243

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

938

What is edw?

1204

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

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

935

Explain the structure of cold fusion?

1046

Explain difference between snow flake and star schema.

1056

Explain what are necessary tasks to install reportnet software?

939

I have two universes created by two difference database can we join them in designer & report level? How

990

Explain multivalued dependency?

995

What is data validation strategies for data mart v?

1095

Explain the difference between view and materialized view?

948

What are the various tools? Explain name a few?

962

What is static and local variable?

1041

Explain what is the difference between power center & power mart?

1003

Explain er diagram?

999

What are the other names given to data warehousing?

1098

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1978

what is user variable in affinium campaign? and some real time examples.

4186

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