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 do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  

---

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

Define mapplet?

0 Answers  

---

What is confirmed dimension?

3 Answers  

---

which one is better performance wise joiner or look up

0 Answers   Informatica,

---

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,

---

Parameter and variable differences

0 Answers  

---

What is a snowflake schema?

0 Answers  

---

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

---

How to display First letter of Names in Caps?

7 Answers  

---

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---