Answer Posted / krishnakanth.ch

It can be retrieved with a simple subquery.

For example, I create a table sal with id,sal

id sal
-------
11 1000
22 1000
33 1000
44 1000

to retrieve the third column with the same salary
use the below query:

select id,sal from (select id,sal,rownum r from sal)
where r=3;

complex mapping ur project u r invlve can u explain and give real time example give me ?

2348

---

Explain the types of lookup transformation?

1101

---

How to extract sap data using informatica?

1092

---

Implementation methodology

1770

---

What is domain and gateway node?

1205

---

What is rank transformation in informatica

1231

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1315

---

What are mapplets? How is it different from a Reusable Transformation?

1134

---

Briefly describe lookup transformation?

1094

---

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

1855

---

How might you approve all mappings in the archive all the while?

1081

---

What is an expression transformation in informatica?

1089

---

What is sorter transformation?

1108

---

waht type of interface is used for testing the data in informatica

2296

---

draw informatica architecture 8.6 ?

3927

---