Answer Posted / murali udayagiri

select greatest(sub.emp_max_sal,sub.emp1_max_sal) from
(select (select max(sal) from emp) emp_max_sal,(select max
(sal) from emp1) emp1_max_sal from dual) sub;



Thanks,
Murali Udayagiri

Can we get 1st record through Informatica(without sequence number).

1460

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2149

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3851

---

What does reusable transformation mean?

1118

---

What are the tasks that source qualifier perform?

1089

---

Where do we use mapping variables in informatica?

1046

---

How do you load first and last records into target table?

1143

---

Explain the pipeline partition with real time example?

1123

---

Explain constraint based loading in informatica

1076

---

When do you use sql override in a lookup transformation?

1079

---

What is expression transformation?

1085

---

What are the different clients of powercenter?

1040

---

What are the components of the workflow manager?

1116

---

What are some examples of informatica etl programs?

918

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1790

---