Answer Posted / sufi

Yes

What are connected or unconnected transformations?

1171

---

explain one complex mapping with logic? sales project?

6729

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8259

---

What is the sequence generator transformation in informatica?

1261

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4147

---

What is the session task and command task?

1111

---

What is complex mapping?

1170

---

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

---

Write the unconnected lookup syntax?

1129

---

Define joiner transformation?

1101

---

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?

1142

---

Design time, run time. If you don't create parameter what will happen

1891

---

Explain what is informatica metadata and where is it stored?

1104

---

Can we create a Integration service without a Repository service and vice versa?

1255

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1125

---