Answer / jz

Performance wise Union all is Fast.

Answer / aparna

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

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

Explain the features of connected and unconnected lookup.

0 Answers  

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

how to run the batch using pmcmd command

2 Answers   Wipro,

---

How do you recover rows from a failed session

1 Answers  

---

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---

Why update strategy and union transformations are active?

0 Answers  

---

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

---

can we override a native sql query within informatica? Where do we do it?

0 Answers  

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---