If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

---

in which situations do u go for snowflake schema ?

2 Answers   TCS,

---

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

6 Answers  

---

When do you use mapping parameters? (In which transformations)

1 Answers  

---

What is the Difference between DSS & OLTP?

5 Answers  

---

What is workflow? What are the components of the workflow manager?

0 Answers  

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

How can you recover the session in sequential batches?

1 Answers  

---

what is the predefined port in dynamic lookup

2 Answers  

---

Explain what are the different versions of informatica?

0 Answers  

---