What is confirmed dimension and fact?

7 Answers  

---

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

How can you differentiate between powercenter and power map?

0 Answers  

---

---

what is confirmed dimension?

6 Answers  

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

How to join three sources using joiner?

0 Answers  

---

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

---

What are batches?

0 Answers  

---

How can you define user defied event?

0 Answers  

---

What do mean by local and global repository?

0 Answers  

---