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  

---

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

---

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,

---

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

---

What is a data modeling?

2 Answers  

---

---

What is informatica? Why do we need it?

0 Answers  

---

What is an expression transformation in informatica?

0 Answers  

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

What is hash partition?

1 Answers  

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

What is a surrogate key?

0 Answers  

---