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 to remove ctrl M or(^M) characters in file using Sequential File stage?

2 Answers   Bank Of America, Satyam,

---

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

---

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,

---

Describe the main features of datastage?

0 Answers  

---

What are the different database update actions available?

1 Answers   HP,

---

How do you import and export data into datastage?

0 Answers  

---

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

---

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

---

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

---

Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,

---

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  

---

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,

---