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 |
Describe in detail about lookup?
How to create a repository in abinitio for stand-alone system(local nt)?
Can anyone give me an exaple of realtime start script in the graph?
. How we can remove temp files of a failed job if .rec is not available
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.
What is difference between force_error & force_abort? How to use in abinitio graph?
What do you mean by data sorting?
What is the difference between partitioning with key / hash and round robin?
Explain about ab initio’s dependency analysis?
In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?
To which project that prefix will set is to private project or public project or both?how and where to set?
Need Ab-Initio Material - Harini