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?

0 Answers  

---

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,

---

Explain what is ods (operation data source)?

0 Answers  

---

What are the different models used in cluster analysis?

0 Answers  

---

Explain what is the metadata extension?

0 Answers  

---

Where we use surrogate key explain with example?

0 Answers  

---

Explain what is the limit to the number of sources and targets you can have in a mapping?

0 Answers  

---

What is latest version of power center / power mart?

0 Answers  

---

Difference between ODS and Staging

4 Answers   HeadStrong, TCS,

---

difference between bo 6.5 and bo xi r2

3 Answers   Accenture, Polaris,

---

what is a hot file, why we need in datawarehousing, where we used in general

2 Answers   Thomson,

---

Explain what are non-additive facts in detail?

0 Answers  

---