Answer / sandhya

detail outer is correct--keeps all the rows from master and
only matching rows from detail.for confirmation see join
types in joiner transformation designer guide

Answer / sarvesh

just in joiner,go to join condition ,put the condition as
masteroutr join,then u get teh data of matched rows frm
both the tables and unmached rows from master table, tehn u
get the data of master table,then u connceted to tgt table.
this is all i guessing,if it is wrong correct me

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

---

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,

---

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

---

---

What is A cache?

2 Answers  

---

What is the difference between informatica 7.0 and 8.0?

0 Answers  

---

difference between shortcut and reusable transformation?

2 Answers  

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

What are the basic needs to join two sources in a source qualifier?

4 Answers  

---