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



What is the significance of record required indicator of Join component ? How to use in abinitio gra..

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

What is the significance of record required indicator of Join component ? How to use in abinitio gra..

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

Post New Answer

More Ab Initio Interview Questions

In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?

2 Answers   IBM, TCL,


Mention what is the syntax for m_dump in abinitio?

0 Answers  


What is a deadlock and how it occurs?

0 Answers  


Can we specify checkpoints without Phases?

3 Answers   IBM, Tech Mahindra,


Can anyone give me an example of realtime start script in the graph?

0 Answers  






How can you view the data in the Multifile

4 Answers   IBM,


Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?

2 Answers  


What is air-project parameter ?

0 Answers  


How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

0 Answers  


what does layout means in terms of Ab Initio?

3 Answers  


Explain the methods to improve performance of a graph?

0 Answers  


What is regex (lookup)? When you should use it? How to use in abinitio graph?

1 Answers   Steria, Wipro,


Categories