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,

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---

What is difference between stored procedure transformation and external procedure transformation?

2 Answers  

---

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

---

What is rank transformation in informatica

0 Answers   Informatica,

---

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

---

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---

how to sort date field in infomatica?

2 Answers  

---

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

---

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---