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 2211Post 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 are the common reasons for errors in accounting?
If we don't have drawing for Excavation of building,At what rule we will go for excavation and how much depth will go for a villa?
Explain what is the role of the zookeeper?
Difference between Logical Page and Physical Page in SSRS.
What is the table, which contains the details of all the name of the programs and forms?
Give an example of Priority Inversion in Scheduling. What are the consequences of Priority Inversion?
Office cash was stolen? state whether the following transcation is business transcation or non business transcation?
What is advanced replication settings? : hana sql script
What is ctrl n in word?
What are the different types of salesforce objects?
What is a workflow field update? : salesforce admin
What do you know about Chief of Planning Commission and Election Commission etc.
Who will done user comparison?
how to calculate the scour depth
Is exe is machine dependent?
