Answer Posted / itsranjan

code should be like this:
Check whether the pk is present, if present, its a duplicate record.
then check for the null values
then check for invalid date columns

iif(not isnull(pk),error_code_dup_rec,
iif(isnull(col1)
or (is null(col2),null_value_
present,
or is null(date),invalid_date,valid_record))

What is the difference between aggregate table and materialized view?

1100

---

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

980

---

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1070

---

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.

1035

---

What is Active Datawarehousing?

1013

---

What is data validation strategies for data mart v?

1090

---

What are snapshots? What are materialized views & where do we use them?

1041

---

Explain difference between view and materialized view?

958

---

What is the difference between agglomerative and divisive hierarchical clustering?

1184

---

What is data mart in data warehouse?

947

---

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

990

---

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

1009

---

How can you import tables from a database?

1085

---

Explain bus schema?

972

---

what is difference between drill & scope of analysis?

1090

---