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 |
Why do you think data processing is important?
Code check-in and check-out commands in AbInitio
What are the different versions and releases of ABinitio ?
what is difference between fuse and join? Explain in detail? In which scenario we will use them?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
What is conduct>it?
What are Cartesian joins?
How many components in your most complicated graph?
i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.
what is the difference between ab_work_dir and .work
In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?
How do we handle if DML changing dynamicaly?
5 Answers GE, HP, IBM, Mannar Company,