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 |
Hi friends i have 3 input files 1 is country file(cid,cname) 2 is State file(cid,sname) 3 is populate file(pid,sid,Adress) I want (cname & total poplation) how i can get the output please help me Thank you
If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this case if we use rollback command then what will happen?
What is is a data flow graph?
Give one reason when you need to consider multiple data processing?
What dedup-component and replicate component does?
Why might the optimizer use a table scan when an index is available?
What are the different types of partition components in abinitio?
What is air_project_parameters and air_sandbox_overrides? what is the relation between them?
Mention what is the syntax for m_dump in abinitio?
What information does a .dbc file extension provides to connect to the database?
what is different daily and monthly develop the abinitio graphs?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?