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

Define joiner transformation?

990

---

scenario where i can use only concurrent execution of workflow.

3067

---

How to load a Dimension ? and how to load a fact table?

1373

---

What is a filter transformation and why it is an active one?

909

---

Differentiate between source qualifier and filter transformation?

1510

---

Explain pmcmd command usage in informatica

1069

---

How can we remove the duplicates from flat file source?

950

---

Explain the mapping variable usage example in informatica

1088

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1976

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1445

---

Clarify the aggregator change?

973

---

What is data movement mode in Informatica and difference between them?

1066

---

What is a sorter transformation?

1042

---

What is the benefit of session partitioning?

1047

---

How to convert multiple rows to single row (multiple columns) in informatica

1319

---