Answer Posted / pg

1. Create S3.
2. Connect it to S4 and S5 prallell. Check if
PreviousTaskStatusS3 =
succeeded in the connecting link.
3. Once S3 is successfully executed it will start S4 and S5
4. Connect s4 and s5 to session s1 and Check if
PreviousTaskStatusS3 =
succeeded in the connecting link and in general tab of
session choose the option treat
input rows as 'OR' .
5. This will allow you to move ahead incase either of S4 or
S5 is succeeded.
6.Connect it to S2 using the same PreviousTaskStatus =
succeeded in the lnk.

Explain the different dimensions.

945

---

What are roles and groups and benefits of using them?

1043

---

What is lookup transformation?

1022

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1058

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2174

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1246

---

tell me 5 session failure in real time how can you solve that in your project?

2265

---

what is Active lock explain

2769

---

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

1897

---

Enlist few areas or real-time situations where informatica is required.

1059

---

Explain the features of connected and unconnected lookup.

918

---

What do you understand by a term domain?

1109

---

expain about the tune parameters?

2394

---

What are active transformations.

1638

---

Explian the Process of deployment groups in informatica

1041

---