What is surrogate key? Where we use it explain with example?
No Answer is Posted For this Question
Be the First to Post Answer
What are the advantages and disadvantages of reporting directly against the database?
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 Answers Extech, Principal Finance,
What is difference between model & package?
if you use oracle sql*loader , how do you transform data with it during loading?
How can we load the time dimension?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain why denormalization is promoted in universe designing?
Explain what is the advantages data mining over traditional approaches?
Explain what are the advantages and disadvantages of reporting directly against the database?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
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 ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
What is operational data store (ods)?