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 IS FACT TABLES?

2 Answers  

What is sql query override? When did u use sql query override?

1 Answers   TCS,

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

What is a surrogate key?

0 Answers  

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,