What is surrogate key?

9 Answers  

---

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

---

why we use datawarehouse

0 Answers   HCL,

---

How can we update a record in the target table without using update strategy?

0 Answers  

---

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

---

Could you explain what is enterprise data warehouse?

0 Answers  

---

WHAT IS FACT TABLES?

2 Answers  

---