Interested to Buy Any Domain ? << Click Here >> for more details...
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 9304Select * 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 7804if we increase the number of dimensions will the rows in fact table increase or decrease??
IBM,
3 9592How 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 4220How 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 5556Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
4 8037in 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 4819hi 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,
2050If 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 6624Post New Data Warehouse General Questions
Explain the main difference between inmon and kimball philosophies of data warehousing?
What are the types of dimensional modeling?
What are the different types of fact tables used in data warehousing?
What is the function of etl when used in data warehousing?
What according to you might be the future of data warehousing?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
Explain what does level of granularity of a fact table signify?
Explain what are the possible data marts in retail sales?
What is a Decision Tree Algorithm?
What are the key columns in Fact and dimension tables?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain the hierarchies level data warehousing.
Explain me what are conformed dimensions?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Suppose we want to display zero when null values coming to report how can we do that?
