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

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6661

---

What do you mean by enterprise data warehousing?

743

---

How many input parameters can exist in an unconnected lookup?

1150

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

738

---

Explain the pipeline partition with real time example?

751

---

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1780

---

Differentiate between Load Manager and DTM?

1760

---

r u done any partitions in ur project?

1475

---

Explain the types of lookup transformation?

691

---

Describe the impact of several join conditions and join order in a joiner transformation?

735

---

generate date / time dimension in informatica

800

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

753

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

791

---

What is joiner change?

803

---

How to load the data from people soft hrm to people soft erm using informatica?

649

---