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

Sequence generator, when you move from develoment to production how will you reset

0 Answers  

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

Can you copy the batches?

3 Answers  

---

What are the databases that informatica can connect to windows?

0 Answers  

---

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

---

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,

---

what is parallel querying and what r hints.

1 Answers  

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

Could you explain what is enterprise data warehouse?

0 Answers  

---

how can i invoke pmcmd in command line prompt

1 Answers  

---

How does a sorter cache works?

0 Answers  

---

How can you generate reports in informatica?

0 Answers  

---