In Join component which record will go to unused port and
which will go to reject port ?
Answer Posted / akj
In case of inner-join all the records not matching the key
specified goes to the respective unused ports, in full
outer-join none of the records goes to the unused ports.
All the records which evaluates to NULL during joiin
transformation will go into reject port if the limit +
ramp*number_of_input_records_so_far <
number_of_input_records_so_far.
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What is $mpjret?
Do you think effective communication is necessary for data processing?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
Explain the methods to improve performance of a graph?
Where $mpjret is used in ab-initio?
Have you used the rollup component? Describe how?
Explain the difference between the truncate and delete commands?
What is ab initio enterprise meta>environment (eme)?
What would be the next step after collecting the data?
Describe what the SQL Server tempdb and tlog files are used for?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
Have you worked with packages?
How can you import XML repositories exported from different tools like ODI
What is a rollup component? Explain about it.