What is the session task and command task?

0 Answers  

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

---

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

---

What is union transformation?

0 Answers  

---

What is the Rank index port in Rank transformation?

0 Answers   Informatica,

---

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---

What are the new features in Informatica 5.0?

1 Answers  

---

What are the two modes of datamovement in informatica sever?

2 Answers  

---