amrita choudhury


{ City } mumbai
< Country > india
* Profession * developer
User No # 28415
Total Questions Posted # 2
Total Answers Posted # 1

Total Answers Posted for My Questions # 4
Total Views for My Questions # 15489

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0
Questions / { amrita choudhury }
Questions Answers Category Views Company eMail

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 Data Warehouse General 8258

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 Data Warehouse General 7231



Answers / { amrita choudhury }

Question { Deloitte, 35723 }

from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data

1. Joiner
2 No cache
3. Static
4. Dynamic


Answer

I wanted to ask, why Static is better than other 3 options.

Is This Answer Correct ?    0 Yes 0 No