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

0 Answers  

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---

Explain the shared cache and re-cache?

0 Answers  

---

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

---

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

In informatics server which files are created during the session rums?

0 Answers  

---

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

0 Answers  

---

guys which is the best institute in banglore to learn informatica??

2 Answers  

---

Mention a few design and development best practices for informatica?

0 Answers  

---

How to update records in Target, without using Update Strategy?

3 Answers  

---