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
How one source columns or rows to be loaded in to two different tables?
How complex jobs are implemented in datstage to improve performance?
What is a quality stage in datastage tool?
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
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?
How many types of sorting methods are available in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Difference between ‘validated ok’ and ‘compiled’ in data stage?
To see hidden files in LINIX?
options available in sequence job to run,validate?
Explain the situation where you have applied SCD in your project?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
what is flow of project?
Triggers,VIEW,Procedures
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.