Answer / keerthiravi

The dimension which can be shared more than 1 fact/module called a conformed dimension. Eg: Time dimension

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  

---

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

---

What is a difference between complete, stop and abort?

0 Answers  

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---

What is the difference between IN and Exists in Oracle?

4 Answers   Deloitte,

---

what is filelist concept in informatica

4 Answers  

---

Clarify the aggregator change?

0 Answers  

---

What are mapping parametres and variables in informatica?

6 Answers   TCS,

---