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 4472Post New Amex Informatica Interview Questions
What is the keyboard shortcut for save as in word?
Is mac built on unix?
how to share the metastore within multiple users?
Does angular js depends on jquery library?
What are the layers in osi reference models? Describe each layer briefly.
Explain about configuration?
A TRANSFORMER 440/400V,DELTA/STAR CONNECTED.THE NEUTRAL CONNECTED WITH GROUND CABLE THAT IS DIRECTLY CONNECTED TO THE PANEL,FROM PANEL IT IS CONNECTED EARTH PIT.IS IT RIGHT? IF IT IS RIGHT LEAKAGE CURRENT AFFECTED.SECONDATY IS PROTECTED WITH EARTH LEAKAGE RELAY.
what are the basic production planning problems?
What is on page and off page optimization?
Cystic fibrosis (CF) occurs with a frequency of about 1/2500 Caucasian newborns and is inherited as an autosomal recessive. A woman had an older sister die from complications of this disease. CF is not present among relatives of her husband. Both the woman and her husband have normal phenotypes. What is the chance this couple will have a CF child?
Can we deploye job tracker other than name node?
how do you round the addition or subtraction of two numbers in assembler? what does the following code do? change process tool(code changes from dev to prd) the changes made to your code should be effected in live. How the process takes place. That is how can you move the code changes from development to production?
What is the no. Of threads created by impala?
Do you know how to implement service broker?
How to handle production department ?