Answer / Smriti Maddheshiya

Informatica's LOOKUP transformation supports several types of joins: Inner Join, Outer Join (Left, Right), Full Outer Join, and Cross Join.

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,

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

What is a stored procedure transformation?

1 Answers  

---

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

---

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

---

Sequence generator, when you move from develoment to production how will you reset

1 Answers  

---

What is decode in static cache?

1 Answers  

---

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

---

What could be the possible resons of locks by user?

1 Answers  

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

Which is the t/r that builts only single cache memory?

1 Answers  

---

How to join three sources using joiner?

1 Answers  

---