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

What is a pre-defined event and user-defined event?

1083

---

Please let me know how to make encryption and decryption with example?

1950

---

Define pmcmd command?

1105

---

What are the databases that informatica can connect to windows?

1098

---

How do you load unique records into one target table and duplicate records into a different target table?

1320

---

Define Pmrep command?

1116

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1081

---

whats the logic to load the lower level of granularity of data to fact table.

2311

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1100

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2350

---

What are Dimensional table?

1121

---

I have a flat file, want to reverse the contents of the flat file

1171

---

What is a difference between complete, stop and abort?

1125

---

Plz can any one say me how to get the informatica certification materials and dumps

2101

---

What are the mapping parameters and mapping variables?

1272

---