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 4480Post New Amex Informatica Interview Questions
What is a linkedhashmap java?
can we use trip light with bus coupler?
How to export your own schema?
How do you define a class and its constructor?
What does <> mean in access query?
What is div and span tag?
what is induction furnance? how many phase supply given io its coil for 15 or 20 ton furnance?
What are the main differences between Loadrunner and QTP tools? Describe briefly a "real world" scenario that would make you use the first one versus the other? Thank you for your answers....
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is the entry point function of a DLL?
is anybody attended interview in ernst&young for EMS PROCESS , pls let me know abt the written test and what type of report writing
Explain penicillin?
What is restful api?
Can you download windows 10 to a flash drive?
Who uses python?