What is the significance of record required indicator of Join component ? How to use in abinitio graph?
- 2 Answers
- 5672 Views
- IBM, TCL, I also Faced
- E-Mail Answers
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 |
What are the steps to create a repository in ab initio?
What are “business rules” in ab initio business rules environment (bre)?
What are the kinds of layouts does ab initio supports?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What do you understand by local lookup?
What are the facts that can compromise data integrity?
What the difference between “look-up” file and “look is up” in abinitio?
Explain how you can run a graph infinitely in ab initio?
What are the differences between different versions of co-op?
what is deeup in unique only?
what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.
Teradata 
