Answer / kak

double click on lookup --->lookup failure --->if it is drop
then it is inner join. If it is continue then it is left
outer join.

Answer / saidarao

GO TO CONSTRAINTS IN LOOKUP PROPERTIES
HERE OPTIONS LIKE-DROP,CONTINUE,FAIL,REJECT .
DROP MEANS MATCHING RECORDS
CONTINUE MEANS LEFT OUTER

How do you load dimension data and fact data? Which is first

2 Answers  

---

what is hash file

2 Answers   CTS, IBM,

---

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

---

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,

---

What is the purpose of interprocessor stage in server jobs?

0 Answers   ASD Lab,

---

What are the various kinds of the hash file?

0 Answers  

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,

---

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

---

How to Remove Duplicate using SQL?

0 Answers   CTS,

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

---

2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?

1 Answers  

---