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 limitations of truncate and load option

1 Answers   Cap Gemini,

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

What is the difference between informatica 7.0 and 8.0?

0 Answers  

Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

How to delete duplicate records in a flat file source?

2 Answers  

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,

How many transformations can be used in mapplets.

0 Answers  

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,