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 3406Post New Amex Informatica Interview Questions
-
Amex Informatica Interview Questions (1)
- Amex SAS Interview Questions (1)
- Amex HR Questions Interview Questions (1)
- Amex SAP SD (Sales & Distribution) Interview Questions (1)
- Amex Electrical Engineering Interview Questions (1)
- Amex Banking Finance Interview Questions (1)
- Amex Audit Interview Questions (1)
- Amex Accounting General Interview Questions (1)
- Amex Call Centre AllOther Interview Questions (4)
- Amex English Interview Questions (1)
- Amex H1B Visa Interview Questions (1)
What activities of production planning is integrated with quality management process?
How do you update a pivot table?
Which of the collections allows null as the key?
Why are mongodb data files large in size?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is clr? Difference between clr & cts?
what is NIH 3T3 transfection?
Why does pre-emptive multi-threading used to solve the central controller problem?
In case you receive a story on the last day of the sprint to test and you find there are defects, what will you do? Will you mark the story to ‘done’?
How do you add an element at the end of an array?
execly, what was your working profile?
Where is the save draft button on wordpress?
How to Send a message to all controls on a form 16-JUL-98?
What qualification do you need to become an accounting professional?
How are free energy changes related to LeChatelier's Principle?
