Answer / kalyan

If the stored procedure id used to do any operations on the
database tables (say Dropping the indexes on the tgt table
or renaming it or truncating it)then call them at the Pre
SQL and Post SQL options at the session properties of the
Target.

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

---

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

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

0 Answers  

---

Briefly define reusable transformation?

0 Answers  

---

What is data movement mode in Informatica and difference between them?

0 Answers  

---

what is mean by flag 4 in update strategy t/r

6 Answers  

---

what is normalizer transformation?

4 Answers   Wipro,

---

What is main use of mapplet?

0 Answers  

---

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

---

how can we use sorter transformation in joins?

5 Answers   IBM,

---

how to declare array in plsql?

1 Answers  

---