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 ?
3 7968Select * 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 ---
1 7056if we increase the number of dimensions will the rows in fact table increase or decrease??
IBM,
3 8093How 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 3469How 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 4769Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
4 6643in 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 4011hi 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,
1634If 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 5825Post New Data Warehouse General Questions
What is VLDB?
What is Analysis Services?
What is the difference between snowflake and star schema?
Suggest a good author for hyperion in data warehousing?
Describe the differences between a data warehouse and data mart.
How to create prompts in report net?
What are non-additive facts in detail?
Can we have multiple application.cfm file in an application?
What are the data types present in bo?
What are the steps involved in creating dimensional modeling process?
What is vdl (view definition language) explain?
Explain what is a cube in data warehousing concept?
Compare cold fusion with other programming languages?
Explain normalization?
Explain what are components of reportnet?