Answer / jz

Only one session for one mapping.

Answer / rakesh

Session represents only one mapping. It makes the mapping available to the workflow for execution.

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

in which situations do u go for scds ?

3 Answers   TCS,

---

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

What is meant by target load plan?

0 Answers  

---

what is hash table in informatica?

1 Answers   Zensar,

---

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,

---

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  

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

How you prepared reports for OLAP?

0 Answers  

---