Answer Posted / rashmi garg

From source to expression connect ID, Name and Amt.
Add one sequence generator and connect to expression
now expression TF is like

expression
----------
ID
Name
Amt
Number

pass number port to aggregator TF to get the max value in
number and pass ID,Name, amt and number from exression to
router and max value from aggregator to router
now router is having ports
Id
Name
Amt
Number
Max

now route the rows on the basis of
number < max/2 (output group 1)
number > max/2 (output group 2)

How do you load only null records into target?

742

---

explain one complex mapping with logic? sales project?

6154

---

What the difference is between a database, a data warehouse and a data mart?

599

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1412

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

557

---

---

What is a repository? And how to add it in an informatica client?

664

---

How are indexes created after completing the load process?

989

---

what is song in infrmatica...?

1685

---

According to his methodology what all you need before you build a datawarehouse

1191

---

State the differences between sql override and lookup override?

629

---

Explain the scenario which compels informatica server to reject files?

661

---

difference between repository database and repository service?

630

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10282

---

Explain target update override in informatica

635

---

How to Create a folder using pmrep command?

626

---