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

Explain ddl (data definition language)?

957

Explain how to generate iqd file from framework manager?

901

How to limit the max no of rows retrieved in the report?

935

Code the tables statement for a single-level (most common) frequency?

881

What is perform recovery?

996

Can we start and stop single session in concurent bstch?

887

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1017

How to provide security in frame work manager for a query subject?

906

How to improve session performance in aggregator transformation?

935

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

953

What is a functional dependency f said to be minimal?

981

How to eliminate duplicate rows from flat file?

882

How to generate the cubes in framework manager?

963

What are target types on the server?

940

What is difference between model & package?

978

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How to calculate fact table granularity?

971

Explain what is power center repository?

949

What is Operational Data Store?

1003

What is the difference between Datawarehouse and OLAP?

886

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2208

What is aggregate fact table?

937

What we will do with the universe for faster process?

922

Explain what are the different types of join operations?

916

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

941

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

920

Explain what are the steps to build the data warehouse?

890

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.

981

Why is business intelligence (bi) important in data warehousing?

880

Explain what are the basic needs to join two sources in a source qualifier?

1018

Explain what is a three tier data warehouse?

910

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