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

What is a difference between complete, stop and abort?

1083

---

What is event and what are the tasks related to it?

1122

---

How to create Target definition for flat files?

1227

---

Which is the t/r that builts only single cache memory?

1190

---

Can we create two repositories on same database instance in oracle?

1095

---

How do you change a non-reusable transformation to reusable transformation?

999

---

What are the different types of olap? Give an example?

1057

---

How is union transformation utilized?

1010

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1040

---

What is meant by a domain?

1129

---

tell me 5 session failure in real time how can you solve that in your project?

2305

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1946

---

How to generate sequence numbers using expression transformation?

1090

---

What are the databases that informatica can connect to windows?

1054

---

where to store informatica rejected data?

1093

---