Answer Posted / infa

If Your Source is Flat file then

1. Sort the sal column in Desc order

2. generate the sequence rownumber either by using a sq
genrator or Exp Transformation say v_count+1

3. use a filter condition and give the filter value as
v_count <= 10

4.Load into the target.

If your source is DB
then use below query

SELECT *FROM
(
SELECT *FROM emp
ORDER BY Sal desc
)
WHERE rownum <= 10
ORDER BY Sal;

Thanks

cheers

Global and Local shortcuts. Advantages.

1472

---

How do you migrate data from one environment to another?

650

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4793

---

What is informatica powercenter repository?

716

---

What are the restrictions of union transformation?

582

---

---

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?

635

---

how tokens will generate?

1739

---

How many ways are there to do 'remove duplicate records in informatica'?

587

---

what is the -ve test case in your project.

1855

---

What differs when we choose the sorted input for aggregator transformation?

576

---

tell me about your project functionality

1870

---

Is it possible to define a single node as a Gateway node as well as worker node?

663

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1564

---

is it possible to index the data in cache of lkp transformation ?

1528

---

lookup transformation with screenshots

3559

---