Answer Posted / prerak3

Hi can you please mail me the dumps on prerak.bvm@gmail.com

How can we use mapping variables in informatica?

1125

---

How do you take back up of repository?

1209

---

Difference between Target-based loading and constraint-based loading?

1042

---

what is the -ve test case in your project.

2459

---

What is informatica?

1218

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2057

---

what is the Default Source Option For Update Strategy Transformation?

1287

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2250

---

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

2392

---

Write the advantages of partitioning a session?

1335

---

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

1959

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1147

---

What do you mean incremental aggregation?

1131

---

What is informatica worklet?

1116

---

How can we remove the duplicates from flat file source?

1075

---