how to identifie,is it innerjoin,leftouter join in lookup?

Answers were Sorted based on User's Feedback



how to identifie,is it innerjoin,leftouter join in lookup?..

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

how to identifie,is it innerjoin,leftouter join in lookup?..

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

Post New Answer

More Data Stage Interview Questions

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,


Name the command line functions to import and export the DS jobs?

0 Answers  


What is the difference between account and directory options ?

0 Answers  


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,


Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers   TCS,






How do u view log file for a particular job?

6 Answers   HP,


SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  


options available in sequence job to run,validate?

0 Answers   CTS,


I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,


Can you explain tagbatch restructure operator?

0 Answers  


Notification Activity

0 Answers   CTS,


what is ds administrator used for?

0 Answers  


Categories