Differentiate between sessions and batches?

0 Answers  

---

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

What is a code page?

0 Answers  

---

whatis the default data driven operation in informatica

2 Answers  

---

---

How to generate sequence numbers?

0 Answers  

---

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

---

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

---

Differences between connected and unconnected lookup?

0 Answers  

---