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 Answers   Amex,

---

What are the different types of schemas?

11 Answers   ITC Infotech,

---

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

---

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

0 Answers  

---

What is query panel?

1 Answers  

---

What is a poling?

2 Answers  

---

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

---

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,

---

What is Micro Strategy? Why is it used for?

5 Answers   Infosys,

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---