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 status code in informatica?

0 Answers  

How do you take back up of repository?

0 Answers  

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

Explain the code page compatibility?

0 Answers  

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,

What is data merging, data cleansing and sampling?

6 Answers   Satyam,

What is predefined event?

1 Answers  

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,