What is the significance of record required indicator of Join component ? How to use in abinitio graph?
Answer Posted / 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 |
Post New Answer View All Answers
What happens when we provide null key to sort, merge and pbks in Abinitio ?
Mention some file extensions which are used in abinitio?
How can I run the 2 gui merge files?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
What exactly do you know about the typical data analysis?
What is a data processing cycle and what is its significance?
Have you used the rollup component? Describe how?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
Explain about ab initio’s dependency analysis?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
Describe what the SQL Server tempdb and tlog files are used for?
Explain what is de-partition in abinitio?
Difference between informatica vs ab initio?
What is the difference between dml expression and xfr expression?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?