Answer / akash

I am not aware of conformed fact but conformed dimension
tables exist.
A conformed dimension is one which is used by more than one
fact table. A classic example of conformed table is a
dimension table which has date fields.

Please let me know if conformed facts exist and their
definition.

Answer / sanjay

A fact which can be used across multiple datamart is called
as confirmed fact. Confirmed fact allows having the same
name in different table.

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---

what is confirmed dimension?

6 Answers  

---

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

Explain about Recovering sessions?

1 Answers  

---

Which kind of index is preferred in DWH?

3 Answers  

---

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

---

What is a sorter transformation?

0 Answers   Informatica,

---

what is semi-additive fact?where did u used?

2 Answers  

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

Can we make worklet inside worklet?

1 Answers  

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---