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

1707

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

1775

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 7938

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 7035

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

IBM,

3 8049

Which is the optimized method of extracting the data.

3 5830

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 3455

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 4745

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

4 6613

what are the similarities between ROLAP and MOLAP

Siemens,

2 13580

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 3995

What's a Cube in Rolap?

Oracle,

2 10237

capital of tamilnadu

Wipro,

6 7119

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,

1624

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 5802


Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the 4 + 1 view model as it relates to system modeling?

572


What is analytical or analytic mean?

598


In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

1687


Where the applications and where

503


Explain about core dimension,

522






Explain what are the methodologies of data warehousing?

509


What is cubes?

598


How to pivot row data using informatica?

489


What are the methodologies of data warehousing?

546


Where the applications and where ware house management system is used?

512


What are the different ways to represent the loading of dimension tables?

497


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

442


How to handle multi value dimensions?

1760


What is meta data and system catalog?

1831


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 meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

515