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

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

---

How do you remove duplicate values in datastage?

0 Answers  

---

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

---

What are system variables and sequencers in datastage

0 Answers  

---

How do u convert the columns to rows in datastage?

0 Answers  

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

0 Answers   Wipro,

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

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,

---

plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,

---

how can we do null handling in sequential files

2 Answers   Reliance,

---

difference between function and procedure...

1 Answers   IBM,

---

How we can covert server job to a parallel job?

0 Answers  

---