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.

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

---

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

0 Answers  

---

What is a code page?

0 Answers  

---

differences between service based and product based?

0 Answers   Satyam,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

---

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

---

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

How do you load first and last records into target table?

0 Answers  

---

What are the rank caches?

2 Answers   Informatica,

---

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---