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

How do you load only null records into target? Explain through mapping flow.

1513

---

What is a dimensional model?

587

---

EXL informatica Questions

945

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1544

---

What are the types of presistent cache in look up tr.

1564

---

---

What is a stored procedure transformation?

620

---

What are the new features of Power Center 5.0?

1246

---

what are the Methods For Creating Reusable Transformations?

660

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

1755

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1064

---

Explain sql transformation in script mode examples in informatica

612

---

How to differentiate between the active and passive transformations?

635

---

Explain lookup transformation in informatica

655

---

Explain pushdown optimization $pushdownconfig parameter - informatica

710

---

Explain the different dimensions.

566

---