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 are the different options used to configure the sequential batches?

2 Answers   Wipro,

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

---

What is a data modeling?

2 Answers  

---

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

---

---

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

---

What are the joiner caches?

3 Answers   Informatica,

---

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

---

What is informatica powercenter repository?

0 Answers  

---

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

---