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

can u any challenge your project?

0 Answers   HP,

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

---

What is source qualifier transformation?

1 Answers  

---

Define enterprise data warehousing?

0 Answers  

---

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

---

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

---

Do you have knowledge in ralph kimball methodology

1 Answers  

---

What is hash partition?

2 Answers  

---

What is the difference between stop and abort in informatica

0 Answers   Informatica,

---

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

---

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

---