Answer Posted / chaitanya

Using SCD2 mapping Target warehouse can store recent data+ complete historical data

Type2 dimension mapping or SCD2 mapping can be implemented in 4 ways: i)Limited number of Histories
ii)Star Schema support implementation
iii)Unlimited number of Histories
iv)Unconnected Stored Procedure

how to create user defined function (udf) in informatica

787

---

Explain scd type 3 through mapping.

588

---

What is fact table? Explain the different kinds of facts.

616

---

How to load a Dimension ? and how to load a fact table?

957

---

How to extract sap data using informatica? What is abap? What are idocs?

560

---

---

What are the data movement modes in informatica?

706

---

How big was your fact table

1320

---

How do you load unique records into one target table and duplicate records into a different target table?

712

---

What is an aggregator transformation?

617

---

What are the different versions of informatica?

684

---

How to call shell scripts from informatica?

577

---

Explain transaction control transformation in informatica

763

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1572

---

What is rank transformation in informatica

693

---

what is the complex transformation you used in informatica

2193

---