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 |
what is the output when -1 is put in select_expr of FBE?
What are differences between different versions of co-op?
I wanted to learn Ab Initio, Could you please send the material to my personal email id.
how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component?
How transaction file different from that of a sort file?
what is the project environment(for each project the environment is same or different to different project)?
How is the partitioning with key different from round robin partition?
Mention what is abinitio?
In MFS i developer developed 2-way, but supporters r supporting 4-way on same records how is possible?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
How to create project (public,private,common,client) what are the differences between them?
What is max core value ? what is the use of it?
2 Answers JPMorgan Chase, Wipro,