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

How union transformation is used?

955

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1986

---

list out all the transformations which use cache?

1112

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1977

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1715

---

where to store informatica rejected data?

1046

---

Define update strategy?

1112

---

Which files are created during the session rums by informatics server?

1123

---

What is deployment group?

1129

---

What is the use of target designer?

981

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2252

---

What is a repository? And how to add it in an informatica client?

1082

---

What are the types of lookup transformation?

1023

---

What are the various types of transformation?

1094

---

What is Index Caches size?

1055

---