Answer / guest

dimensional table stores the textual description of data
whereas fact table stores numerical values.

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

what is unique constraint error ?

2 Answers   TCS,

---

What is informatica?

0 Answers  

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

Differentiate between router and filter transformation?

0 Answers  

---

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

What is A cache?

2 Answers  

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

---

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

---