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

Why update strategy and union transformations are active? Explain with examples.

0 Answers  

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

---

What is the function of aggregator transformation?

0 Answers  

---

expain about the tune parameters?

0 Answers   TCS,

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

How to update a particular record in target with out running whole workflow?

0 Answers  

---

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

---

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

---

Write the prerequisite tasks to achieve the session partition?

0 Answers  

---

How many number of sessions can one group in batches?

0 Answers  

---