Answer / santhoshn

A fact table without any facts is called as factless fact table.

Answer / 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

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,

---

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

---

How many cubes create from a single model?

1 Answers  

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

Define sessions in informatica etl?

0 Answers  

---

In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,

---

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

---

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

---

Explain what is informatica metadata and where is it stored?

0 Answers  

---

what is flat file override?

1 Answers   Cap Gemini, HP,

---