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 is the function you would use to transfer a string into a decimal?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
Can anyone give me an example of realtime start script in the graph?
Why might the optimizer use a table scan when an index is available?
When we should use 'jobid' for commit table (Output table component??
How can you import XML repositories exported from different tools like ODI
How does the bre work with the co>operating system?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
What is the difference between look-up file and look-up, with a relevant example?
What information does a .dbc file extension provides to connect to the database?
In abinitio, what types of parallelism are used?
What a local lookup is?
What are the factors on which storage of data depends?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
What exactly do you know about the typical data analysis?