What is meant by active and passive transformation?

0 Answers  

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

what is confirmed dimension?

6 Answers  

---

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

---

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

---

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

What is mapping debugger?

0 Answers  

---

Explain lookup transformation source types in informatica

0 Answers   Informatica,

---

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---