Answer Posted / isha_gtb

Enable Test Load : You can select this option to allow only a few records to
pass through the mapping. This option is useful when
you are in the testing phase of your project.


Number of rows to test : When you select the Enable Test Load option, you
can define the number of records you wish to flow
from Mapping. Suppose you have 10,000 records to
process. You can check the Enable Test Load option
and mention the number of records you wish to test. So,
if you define 100 records, Informatica will only process
100 records out of the 10,000 records.

What are the tasks that source qualifier perform?

1145

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1307

---

Clarify the utilization of aggregator cache record?

1044

---

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

1080

---

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

10728

---

Explain the scenario which compels informatica server to reject files?

1208

---

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?

10321

---

How might one distinguish in the case of mapping is right or not without associating session?

1197

---

How can we use batches?

1064

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2174

---

What is the command used to run a batch?

1111

---

Describe the impact of several join conditions and join order in a joiner transformation?

1115

---

design of staging area?

2075

---

What is informatica powercenter repository?

1256

---

Why filter transformation is an active one?

1033

---