Answer / prateek

select distinct sal from emp e1 where 3 = (select count(distinct sal) from emp e2 where e1.sal <= e2.sal);

Answer / mahaboob basha

select users.user_id, users.email, max(classified_ads.posted)
from users, classified_ads
where users.user_id = classified_ads.user_id
group by users.user_id, users.email
order by upper(users.email);

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

---

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

How do you migrate data from one environment to another?

0 Answers  

---

---

Write the unconnected lookup syntax?

0 Answers  

---

How will you update the row without using update statergy?

10 Answers   CTS,

---

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

---

Clarify the utilization of aggregator cache record?

0 Answers  

---

Can you create a flatfile target

3 Answers   ABC,

---

what is mean by flag 4 in update strategy t/r

6 Answers  

---

how do u tune queries?

1 Answers  

---