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

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

How to open an older version of an object in the workspace?

0 Answers  

---

How union transformation is active ?

2 Answers   Puma,

---

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

---

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

What are the different caches used in informatica?

3 Answers   UST,

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---