Answer / 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))

Explain Association algorithm in Data mining?

0 Answers  

---

What is normalization, first normal form, second normal form, third normal form?

0 Answers  

---

what is the difference between DSS and ODS ?

2 Answers   IBM, Satyam,

---

Explain difference between view and materialized view?

0 Answers  

---

What is an error log table in informatica occurs and how to maintain it in mapping?

0 Answers  

---

What is Time Series algorithm in data mining?

2 Answers  

---

What is cubes?

0 Answers  

---

I have two universes created by two difference database can we join them in designer & report level? How

0 Answers  

---

What is difference between a connected look up and unconnected look up?

1 Answers  

---

What is Grain & Granularity in Data Warehouse.

2 Answers   TCS, TVS,

---

What needs to be done when the database is shutdown?

0 Answers  

---

How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 Answers  

---