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.

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,

---

How can you increase the performance in joiner transformation?

0 Answers  

---

how to obtain performance data for individual transformations.

2 Answers  

---

What are the tasks that source qualifier performs?

1 Answers  

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

---

Which files are created during the session rums by informatics server?

0 Answers  

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,

---

In informatics server which files are created during the session rums?

0 Answers  

---