when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

---

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

---

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

---

What is souce qualifier transformation it is active or passive

2 Answers   HCL,

---

Please let me know how to make encryption and decryption with example?

0 Answers  

---

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

---

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

---