Answer Posted / guest

update emp a set a.sal=a.sal+500 where a.hiredate in(select
max(b.hiredate) from emp b group by b.hiredate having
count(b.hiredate)>1);

or

update emp a set a.sal=a.sal+500 where a.hiredate=(select
max(b.hiredate) from emp b where a.hiredate=b.hiredate group
by b.hiredate having count(b.hiredate)>1);

What is an expression transformation?

1024

---

What is the scenario which compels informatica server to reject files?

1075

---

What is difference between a gateway node and worker node?

1146

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2130

---

expain about the tune parameters?

2421

---

What is informatica?

1164

---

How to implement security measures using repository manager?

1184

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1689

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7190

---

How union transformation is used?

1012

---

How can you differentiate between powercenter and power map?

1095

---

explain one complex mapping with logic? sales project?

6679

---

How many transformations can be used in mapplets.

1941

---

Could you explain what is enterprise data warehouse?

1151

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2014

---