What is the significance of record required indicator of Join component ? How to use in abinitio graph?
Answers were Sorted based on User's Feedback
Answer / narrenderan
Inner Join
Record-required-0 = True
Record-required-1 = True
Outer Join
Record-required-0 = False
Record-required-1 = False
Inner join is matching records on both input , so both must be set to true and vice versa for outer join
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / keerthika
when we specify Explicit Join user has privilege to tell how the records need to got to output, here is the detailed meaning behind
Left Outer Join
Record-required-0 = True
Record-required-1 = false
Right outer Join
Record-required-0 = False
Record-required-1 = True
Outer Join
Record-required-0 = True
Record-required-1 = True
Inner Join
Record-required-0 = False
Record-required-1 = False
| Is This Answer Correct ? | 3 Yes | 4 No |
How can we increase the loading performance of oracle table in AbInitio?
What are the factors on which storage of data depends?
Is there any function in ab Initio which act like SCAN component
What do you mean by continuous graph? what is it significance?
How can you achieve scan using reformat ?
What is standard environment ? How to use in abinitio graph?
We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?
What is conditional DML and Structured DML?
Describe step by step the process of creating tag and savefile for migration
What is the difference between rollup and scan?
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
How do you improve the performance of a graph?