Answer Posted / jvdwhinfo

Write sql override in the source qualifier t/r.
select columns from
( select columns,rank() over(order by sal desc ) as
rank from emp)
where rank <=10;
let me know if any corrections.

Thanks.
James

Clarify the aggregator change?

1034

---

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

1192

---

can anyone explain me about retail domain project in informatica?

7950

---

What is session task and command task?

1305

---

Explain your project of banking domian.

1654

---

Have you worked with/created Parameter file

1668

---

Explain the types of lookup transformation?

1047

---

What does role playing dimension mean?

1050

---

Explain what are the different types of transformation available in informatica.

1152

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1207

---

What is the need of an ETL tool?

1107

---

How to update or delete the rows in a target, which do not have key fields?

1181

---

What is rank transformation in informatica

1179

---

How we can use union transformation?

1063

---

is it possible to index the data in cache of lkp transformation ?

2033

---