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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How one source columns or rows to be loaded in to two different tables?

668


How complex jobs are implemented in datstage to improve performance?

604


What is a quality stage in datastage tool?

634


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

781


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?

1760






How many types of sorting methods are available in datastage?

638


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2710


Difference between ‘validated ok’ and ‘compiled’ in data stage?

681


To see hidden files in LINIX?

948


options available in sequence job to run,validate?

844


Explain the situation where you have applied SCD in your project?

1568


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1726


what is flow of project?

1561


Triggers,VIEW,Procedures

805


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1672