how to identifie,is it innerjoin,leftouter join in lookup?
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 42 Yes | 1 No |
Answer / saidarao
GO TO CONSTRAINTS IN LOOKUP PROPERTIES
HERE OPTIONS LIKE-DROP,CONTINUE,FAIL,REJECT .
DROP MEANS MATCHING RECORDS
CONTINUE MEANS LEFT OUTER
| Is This Answer Correct ? | 4 Yes | 0 No |
What are the areas of application?
How do you remove duplicate values in datastage?
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
when u face critical situation in ur project, how to solve them?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
What are the components of ascential data stage?
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
Where the datastage stored his repository?
Can aggregator and transformer stages use to sort the data? How ?
How can we improve performance of data stage jobs?
what is the best stage in datastage parller jobs to use full out join and why
what is data mapping