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 are connected or unconnected transformations?

0 Answers   Informatica,

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

---

What are the uses of a Parameter file?

3 Answers   CSC,

---

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

---

what is runtime variable?

3 Answers   TCS,

---

wf dont have integration severances how you can run?

0 Answers   TCS,

---

what is scd?

6 Answers  

---

what is normalizer transformation?

4 Answers   Wipro,

---

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

---

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

---

what is incremental data aggregation?

3 Answers   IBM,

---