Answer Posted / rekha

A FACT TABLE WITHOUT FACT IS CALLED FACT LESS FACT TABLE
SUPPOSE WE NEED TO COMBINE TWO DATAMARTS ,ONE DATAMART
CONATINS FACT LESS FACT TABLE AND ANOTHER DATAMART WITH
THE FACT TABLE
FACT LESS FACT TABLES ARE USED TO CAPTURE DATE TRANSACTION
EVENTS


CHEERS,
REKHA

What is the Rank index port in Rank transformation?

1064

---

What are the various types of transformation?

1183

---

How are indexes created after completing the load process?

1655

---

what is Active lock explain

2807

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1060

---

Explain the pipeline partition with real time example?

1144

---

explain about unit testing? in real time?

2210

---

What is Cognos script editor?

4240

---

What is Data Caches size?

1095

---

What can we do to improve the performance of informatica aggregator transformation?

1097

---

How do you load only null records into target? Explain through mapping flow.

2032

---

Global and Local shortcuts. Advantages.

2037

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2257

---

Define filter transformation?

1103

---

what is the hint? how to use it to reduce the query processing in program?

7842

---