Answer / siva

Fact table contains facts,measures or numerical vlues. Foe
example if your business process is 'sales' then a
measurment of this business process contains name of the
product,price of product,location and date and time of the
product sales.It also contains foreign keys of all the
dimension tables.

Answer / rekha

Fact table is the primary table in the dimensional
modeling . the numerical performance of measures of the
business stored in fact table
mostly used facts ara numeric and additive
not every numeric is a fact ,but a numeric wich ara of type
key performance indicator is called fact

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

---

What is staging area?

11 Answers  

---

How to retrieve last two days updated records?

4 Answers  

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

How to extract original records at one target & Duplicate records at one target?

12 Answers  

---

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

---

what is target load plan

2 Answers   Cap Gemini,

---

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---

How many input parameters can exist in an unconnected lookup?

0 Answers  

---