Answer Posted / avatar dss42b88

for this we use sequence generator t/r,
ex take source emp
targets -emp1,emp2,emp3.
mapping structure

sq->(seq)->exp->rtr->emp1(condition rowid=1)
->emp2(condition rowid=2)
->emp3(condition rowid=3)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like

start value=1
increment by=1
last value=3
currval=1
cycle check it save it.
execute mapping.

where to store informatica rejected data?

1139

---

In how many ways we can create ports?

1160

---

what is the difference between informatica6.1 and infomatica7.1

2362

---

What are pre and post-session shell commands?

1389

---

State the limitations where we cannot use joiner in the mapping pipeline?

1107

---

How many number of sessions can one group in batches?

1216

---

How can repository reports be accessed without sql or other transformations?

1268

---

Explain in detail scd type 2 through mapping.

1092

---

What is meant by incremental aggregation?

1185

---

Write the prerequisite tasks to achieve the session partition?

1230

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282

---

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

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1727

---

Target increases every day even though no new record was inserted

1625

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2481

---