Answer Posted / sandeep.t nizamabad

DIMENSIONS ARE CLASSIFIED INTO THREE TYPES
SCD TYPE-1 (MAINTAIN CURRENT DATA)
SCD TYPE-2 (MAINTAIN CURRENT DATA+FULL HISTORY OF CHANGES)
SCD TYPE-3 (MAINTAIN CURRENT DATA+ONE TIME HISTORY)

How are indexes created after completing the load process?

1638

---

have u done any performance tuning? how u ll do?

2298

---

How to load data in informatica ?

1003

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1901

---

Explain the use of aggregator cache file?

1247

---

Describe data concatenation?

1077

---

Explain sql transformation in script mode examples in informatica

1130

---

How to join three sources using joiner?

1104

---

How will the document be delivered to me?

1079

---

Informatica settings are available in which file?

988

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2177

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2195

---

Plz can any one say me how to get the informatica certification materials and dumps

2045

---

How can we create index after completion of load process?

1119

---

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

1049

---