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;

What is union transformation?

575

---

Can you generate sequence numbers without using the sequence generator transformation?

601

---

What do you understand by a term domain?

670

---

What is parallel processing in informatica?

1031

---

What does command task mean?

614

---

---

Explain what transformation and how many are there in informatica?

486

---

Enlist the advantages of informatica.

632

---

Partition, what happens if the specified key range is shorter and longer

2031

---

What are the static cache and dynamic cache in informatica?

718

---

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

627

---

Can we override a native sql query within informatica?

632

---

What are the different options available for update strategy?

580

---

What are the differences between source qualifier and joiner transformation?

598

---

How to open an older version of an object in the workspace?

618

---

What are data-driven sessions?

715

---