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);

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

---

Which kind of index is preferred in DWH?

2 Answers  

---

Define Update Override?

1 Answers  

---

what is the use of Data Mart?

5 Answers   IBM,

---

What is a taget load order?

2 Answers   IBM,

---

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---

Can you start a session inside a batch individually?

2 Answers  

---

How do you set a varible in incremental aggregation

0 Answers  

---

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

Write the prerequisite tasks to achieve the session partition?

0 Answers  

---