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

How can you complete unrcoverable sessions?

1 Answers  

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---

How can you access the remote source into your session?

1 Answers  

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

can anyone suggest best free Talend data integration training online

0 Answers  

---

---

What is staging area?

11 Answers  

---

Where do we use mapping variables in informatica?

0 Answers  

---

Explain what is informatica metadata and where is it stored?

0 Answers  

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  

---

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---