1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

How many repositories can we create in Informatica?

3 Answers  

---

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,

---

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

---

Can we create two repositories on same database instance in oracle?

0 Answers  

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

What are different types of transformations available in informatica?

0 Answers  

---

what is difference between dimention table and fact table?

1 Answers  

---

What is parallel processing in informatica?

0 Answers  

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

---

Why use shortcuts(Instead of making copies).

1 Answers  

---