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

Explain dynamic target flat file name generation in informatica

1109

---

design of staging area?

2075

---

Differentiate between joiner and lookup transformation?

1159

---

What is the commit type if you have a transaction control transformation in the mapping?

1098

---

What are pre and post-session shell commands?

1387

---

What is Index Caches size?

1163

---

What is status code in informatica?

1063

---

What is a filter transformation?

1091

---

How can we improve session performance in aggregator transformation?

1153

---

Explain Dataware house architecture .how data flow from intial to end?

2647

---

Explain the tuning lookup transformation - informatica

1044

---

how we can load rejected record's at run time?(not through bad files)

2426

---

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

5789

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1112

---

what is the size of your data warehousing?

2144

---