Answer Posted / bhupal

if you use the update strategy transformation before joiner in mapping, the mapping will be invalid because of data flow validation errors in mapping irrespective of operations you implemented in update strategy.

joiner transformation input should be from source qualifier transformation.

source---->sq--->seq--->
joiner---->trg
source---->sq---->

we cant create mapping like this because seq does't allows port to create and accept from other tr.

src--->sq--->
joiner--->trg
seq--->
we cant create like this. joiner inputs should be from source qualifier.

Explain the tuning lookup transformation - informatica

1043

---

What are the performance considerations when working with aggregator transformation?

1201

---

What is the commit type if you have a transaction control transformation in the mapping?

1095

---

Performance tuning( what you did in performance tuning)

2052

---

Which are the different editions of informatica powercenter that are available?

1079

---

What is incremental aggregation?

1134

---

What are 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?

1120

---

What does cheating measurement mean?

1105

---

If informatica has its scheduler why using third party scheduler?

1302

---

Explain scd type 3 through mapping.

1051

---

What is a stored procedure transformation?

1109

---

Explain sessions. Explain how batches are used to combine executions?

1077

---

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

1951

---

Explain informatica architecture - version 8 / 9

1144

---

Explain about cumulative Sum or moving sum?

1090

---