Answer / gurpreet singh

Normal Join - All matching rows of A and B
Master Outer join - All rows of detail including matching
rows from master
Detail Outer join - All rows of Master including matching
rows from detail.
Full outer join - All rows from Master and detail table
including matching rows.

Different circumstance which drives informatica server to expel records?

0 Answers  

---

What is the reusable transformation?

0 Answers  

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

---

How many cubes create from a single model?

1 Answers  

---

what is song in infrmatica...?

0 Answers   CTS,

---

What are the different caches used in informatica?

3 Answers   UST,

---

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

---

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

---

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

---

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

---