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 do u move the code from development to production?

3 Answers  

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---

Explain lookup transformation is active in informatica

0 Answers   Informatica,

---

What is the difference between stop and abort in informatica

0 Answers   Informatica,

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---

why we r using presql&postsql in source qualifier?

1 Answers   HP,

---

How we can create indexes after completing the loan process?

0 Answers  

---

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

---

my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  

---

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

0 Answers  

---

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---