what is diffrence b/w joner and union transfermation

6 Answers  

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

---

why we need informatica

2 Answers   HCL,

---

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

---

How do you implement scheduling in Informatica?

1 Answers  

---

What is meant by incremental aggregation?

0 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---