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?

982

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?

976

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

1017

How to test report in reportnet?

1054

What are aggregate transformation?

1094

Tell me what is degree of a relation?

1054

How to create prompts in report net?

1040

What is the difference between power center and power mart?

1081

What is the difference between filter and lookup transformation?

1177

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

1013

In document how to create metrics?

1045

Is union transormation is active transformation?

1021

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

1325

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

997

What is edw?

1269

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain clustering algorithm?

2332

Explain what are data marts?

1196

I need to set predefined condition. How I do this?

1064

What is a view as it relates to system modeling?

1031

What is the difference between connected and unconnected stored procedures?

1149

What a static and local variable?

1134

Explain what is data validation strategies for data mart validation after loading process?

1077

Explain what are the modules in power mart?

1094

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

1017

Explain er diagram?

1036

What is conformed fact?

1150

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1097

what are different storage options supported by oracle ?

2136

What is the data type of the surrogate key?

1073

What is informatica architecture?

1112

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