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 1507Post New Amex Informatica Interview Questions
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
sir i want model and previous year question paper of RRB. please send it to my mail id. im a mechanical engg.
What is the source of dependent source ?
regarding bsnl jto examination,can i use the printout of application format mentioned in the advertisement.
What is the RMS and DFT principle of analogue maesurments. Which way they are advangages. where which princples give optimum results.
Hello Can anyone please share the interview details for QA positions in Tribal Fusion, Noida. Much Thanks
How to file the CST return and which form is use.
How did you arrive at the sales of your industry and its growth rate? - Venture Capitalists
what was the rate of duty i have to pay if i want to import 1) lubricants(engine oil, etc) 2) grease 3) v-belts(rubber belts used in machines, cars, etc)
OUR COMPANY IS ENGGAGED IN CONSTRUCTION ACTIVITY .WE ARE GOING TO PURCHASE EXACAVATOR MACHINE FROM THE INTERSTATE.WHETHER THE ABOVE PURCHASE COVERED BY ISSUING THE C FORM.
Can anyone list out major scenarios for an application managing drug composition?
Tell about your role in project u did?
Have you ever been charged with training and coaching other sales professionals?
How to Embede a copyright symbol in a string?
How should requirements on middleware performance be characterized?
