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 data movement mode in Informatica and difference between them?

1120

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2399

---

Describe the impact of several join conditions and join order in a joiner transformation?

1051

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1070

---

What is the difference between informatics 7x and 8x and what is latest version?

1072

---

What is a filter transformation?

1027

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1108

---

What is sorter transformation?

1029

---

Whats there in global repository

1676

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5764

---

Name the different lookup cache(s)?

1219

---

explan ur project architecture?

2047

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1119

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2044

---

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

2004

---