What are the designer tools for creating transformations?

0 Answers   Informatica,

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

how can u load the data in time dimension?

3 Answers  

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

Explain how many types of dimensions are available in informatica?

0 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

---

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  

---

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---