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

Explain the informatica workflow?

582

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8525

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1838

---

Repository user profiles

1371

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1633

---

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2269

---

Global and Local shortcuts. Advantages.

1460

---

On which transformations you created partitions in your project?

758

---

What is data caches/ index caches?

607

---

What are the tasks that source qualifier perform?

627

---

How can you validate all mappings in the repository simultaneously?

751

---

What is meant by lookup transformation? Explain the types of lookup transformation?

562

---

How we can use union transformation?

605

---

Define update strategy?

630

---

How to load the data from a flat file into the target where the source flat file name changes daily?

572

---