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.

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1013

---

What are the types of schemas we have in data warehouse.

963

---

What is Cognos script editor?

4235

---

What is the Rank index port in Rank transformation?

1061

---

How can you increase the performance in joiner transformation?

1191

---

What do you mean by channel change?

1048

---

Briefly describe lookup transformation?

1046

---

How we can use union transformation?

1052

---

Explain in detail about scd type 1 through mapping.

1555

---

explain one complex mapping with logic? sales project?

6671

---

What all are steps in up gradation of Informatica server?

1046

---

What are the limitations of joiner transformation?

1114

---

What can we do to improve the performance of informatica aggregator transformation?

1095

---

What is expression transformation?

1103

---

What are the main issues while working with flat files as source and as targets ?

1163

---