Answer / priyank

There are some keys which are present in the fact table but
they do not have a corresponding Dimension table related to
them. These are called Degenerated Dimensions.

Eg. Transaction No., Invoice No.

what is difference between dimention table and fact table?

1 Answers  

---

what is a transforamation?

5 Answers  

---

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

---

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

Tell me about informatica architecture.

2 Answers   TCS,

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

---

What is the fact table?

0 Answers  

---

What is difference between maplet and reusable transformation?

2 Answers  

---

How to extract original records at one target & Duplicate records at one target?

12 Answers  

---

How might you approve all mappings in the archive all the while?

0 Answers  

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---