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

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

1 Answers  


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?

4 Answers   IBM,


What is is a data flow graph?

0 Answers  


Give one reason when you need to consider multiple data processing?

0 Answers  


What dedup-component and replicate component does?

0 Answers  






Why might the optimizer use a table scan when an index is available?

0 Answers  


What are the different types of partition components in abinitio?

0 Answers  


What is air_project_parameters and air_sandbox_overrides? what is the relation between them?

1 Answers   IBM,


Mention what is the syntax for m_dump in abinitio?

0 Answers  


What information does a .dbc file extension provides to connect to the database?

0 Answers  


what is different daily and monthly develop the abinitio graphs?

1 Answers   TCS,


What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

0 Answers  


Categories