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

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

2324

how much memory space occupied real time project (roughly)?

2284

If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

Extech, Principal Finance,

3 9451

Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---

Principal Finance, PT Metalogix Infolink Persada,

1 7874

if we increase the number of dimensions will the rows in fact table increase or decrease??

IBM,

3 9721

Which is the optimized method of extracting the data.

3 7455

How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 4287

How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

IBM,

1 5635

Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.

4 8183

what are the similarities between ROLAP and MOLAP

Siemens,

2 14874

in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do

IBM,

1 4900

What's a Cube in Rolap?

Oracle,

2 11876

capital of tamilnadu

Wipro,

6 9850

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

L&T,

2097

If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?

CSC,

1 6712

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain about core dimension,

1036

What are the advantages and disadvantages of reporting directly against the database?

1019

Explain what are components of reportnet?

1025

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

2020

Explain what are the methodologies of data warehousing?

968

Where do we use semi and non additive facts?

1039

Explain the definition of normalized and denormalized view and what are the differences between them?

973

What are the different types of scd's used in data warehousing?

1291

Explain what are the advantages of query studio compared to report studio?

1059

What is an error log table in informatica occurs and how to maintain it in mapping?

1006

Explain me what are data marts?

1106

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

959

Code the tables statement to produce a multi-level frequency?

1046

Explain the versions of reportnet?

1041

what are the others of "bad files" and "discard files" when using sql*loader?

2179

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