Answer Posted / 9885657928

Ya it is possible to connect the two fact tables By using
Schemas.
Eg:Hybrid schema or Gelaxy schema

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1042

---

How can you implement many relations in star schema model?

1007

---

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

966

---

What is surrogate key? Where we use it? Explain with examples.

1034

---

Explain what are conformed dimensions?

1093

---

Explain how to export mappings to the production environment?

980

---

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

965

---

Explain what is fact less fact table? Where you have used it in your project?

935

---

Why denormalization is promoted in universe designing?

991

---

What are vaious etl tools in the market?

1008

---

if you use oracle sql*loader , how do you transform data with it during loading?

2109

---

Explain what is partitioning? What are the types of partitioning?

973

---

Fact table is in normalized or de-normalized form?

969

---

What is the difference between mapping parameter & mapping variable in data warehousing?

993

---

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2344

---