Answer / jz

Performance wise Union all is Fast.

Answer / aparna

Performance wise Union All is faster , because Union removes the duplicate records.

What is Code Page Compatibility?

1 Answers  

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

How many ways you create ports?

1 Answers  

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

---

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  

---

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

When do you use sql override in a lookup transformation?

1 Answers  

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

What is difference between a gateway node and worker node?

1 Answers  

---

What is target designer and target load order?

1 Answers  

---

explain about informatica server architecture?

1 Answers   IBM,

---