What is the significance of record required indicator of Join component ? How to use in abinitio graph?
Answer Posted / 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 |
Post New Answer View All Answers
Describe the evaluation of parameters order in ab initio?
Explain what is sort component in abinitio?
What is the architecture of abinitio?
Do you know what a local lookup is?
What do you understand by local lookup?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
what is the output when -1 is put in select_expr of FBE?
What is sandbox?
What does de-partition mean in abinitio?
Explain about ab initio’s dependency analysis?
What are the differences between informatica and abinitio?
What is de-partition in abinitio?
Mention what the difference between “look-up” file and “look is up” in abinitio?
What are the six data process products of ab initio (architecture of ab initio)?
Why might the optimizer use a table scan when an index is available?