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 3839Post 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)
Explain what event gets fired after db update?
What is scala option?
Suppose we have object b and aggregated object c (in- proc server), created by b. Can you access any interface of b from c? What?s the difference between aggregated and contained objects?
What are the things that you must define for each external dependency?
Which aircraft use uses automatic fuel transfer system and which aircraft uses semi automatic
Can you explain equivalence partitioning?
Can you explain what SAP Process Orchestration (PO) is and its primary functions?
Is hadoop open source?
What is the use of statistic data item ?
what are the differences between Generic server and application server in WebSphere environment?
What is the Use of the inet_makeaddr() Function?
What do you understand by middleware?
What are the exception handling operators in Pig script?
How can I debug my sapscript?
List the data types supported in aidl?
