Answer Posted / asha

2 purposes of factless fact

1. Coverage : to indicate what did NOT happen. Like to
answer questions like which product did not sell well in a
particular region.

2. Event tracking: To know if the event took place or not.
Like: Fact for tracking students attendence will not
contain any measures.

What is data analytics in simple terms?

1262

---

Explain differences between star and snowflake schemas?

1235

---

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1178

---

What are vaious etl tools in the market?

1050

---

What are necessary tasks to install reportnet software?

976

---

What are algorithms provided by Microsoft in SQL Server?

2108

---

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

992

---

What is crass reference table?

1096

---

Define Data Warehousing?

1198

---

What are the advantages and disadvantages of reporting directly against the database?

1019

---

How can we run the graph? What is the procedure for that?

990

---

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

1122

---

How to design file watch jobs?

1019

---

How to stop a batch?

1032

---

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

971

---