Answer Posted / harish konda

First connect the exp1 with source and Sequence t/f's.

And next take the sorter and sort the data in descending
order of NEXTVAL port.

And again connect sorter to exp2 and connect sequence t/f to
this exp2.

And then connect this exp2 to router and give these
conditions NEXTVAL=1(of first sequence) and NEXTVAL=2(of
second sequence) then rout to the target.

What is the command used to run a batch?

1112

---

In informatica workflow manager, how many repositories can be created?

1438

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1125

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2192

---

Define filter transformation?

1149

---

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

---

How do we call shell scripts from informatica?

1191

---

What is incremental aggregation?

1137

---

Implementation methodology

1773

---

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

1107

---

What are the new features of informatica 9.x in developer level?

1053

---

Explain pushdown optimization and types in informatica

1122

---

what is INFORMATICA TESTING process

2334

---

What are different types of transformations available in informatica?

1060

---

Name the different lookup cache(s)?

1294

---