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

Describe in detail about lookup?

1 Answers  


How to create a repository in abinitio for stand-alone system(local nt)?

1 Answers  


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

1 Answers  


. How we can remove temp files of a failed job if .rec is not available

2 Answers  


what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.

1 Answers   IBM,


What is difference between force_error & force_abort? How to use in abinitio graph?

2 Answers   IBM, TCL,


What do you mean by data sorting?

1 Answers  


What is the difference between partitioning with key / hash and round robin?

1 Answers  


Explain about ab initio’s dependency analysis?

1 Answers  


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

2 Answers   IBM, TCL,


To which project that prefix will set is to private project or public project or both?how and where to set?

1 Answers  


Need Ab-Initio Material - Harini

7 Answers  


Categories