Answer / raka

SQL:
SELECT id, salary from <table name> where rownum <= 10
ORDER BY salary DESC;

Answer / abhilash

do following steps

1.in source qualifier override the query with
"order by salary desc"

2. use seq gen tr on it and give column name as "sid"

3. next use filter tr. in that write condition like "sid<=10"

Answer / amedela chandra sekhar

write sql query in the source qualifier t/r

sql override

select * from(select dense_rank () over (order by sal desc
nulls last)as rnk,emp.* from emp)where rnk<=10;

Answer / krishnakanth

I hope the simpliest way is what Raka #4 suggested
We can override in the SQL override in the source qualifier
transformation.

Answer / murugan

only use the Aggregator function.....

first(sal>=values)

Answer / sarvesh

if it is flat file ur answer is write,if it is relational
souce then go to source qualifier properties there u write
the query like
select distinct a.* from t1 a where 10=(select sal from
t1 b where a.sal>b.sal)
i think it is working

What are the new features of informatica 9.x developer?

0 Answers  

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

Can we update the data in flat file using update strategy?

3 Answers  

What are the challenges of Dataware housing in the future?

2 Answers   HP,

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

plz plz plz send client names and project names in informatica?

1 Answers  

How you count the number of records available at your source?

3 Answers   Zensar,