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 informatica? What exactly are the practical uses in real world

2 Answers  

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

How can we create index after completion of load process?

0 Answers  

---

When you move from devel to prod how will you retain a variable

1 Answers  

---

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

---

How big was your fact table

0 Answers  

---

How do you migrate data from one environment to another?

0 Answers  

---

How to delete duplicate record in Informatica?

7 Answers  

---

How to update source definition?

0 Answers  

---

what is session override?

2 Answers   Cap Gemini,

---

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

---