how to identifie,is it innerjoin,leftouter join in lookup?
- 2 Answers
- 34555 Views
- Hexaware, I also Faced
- E-Mail Answers
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 ? | 41 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 |
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
How to perform incremental load in datastage?
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
what is the use of surogate key in datastage
Explain the ChangeApply stage?
what is mapping lookup
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
What are the functionalities of link partitioner and link collector?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
How a source file is populated?
Teradata 
