In Join component which record will go to unused port and
which will go to reject port ?

Answers were Sorted based on User's Feedback



In Join component which record will go to unused port and which will go to reject port ?..

Answer / kumarg

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. In
case of reject port, records which do not match with DML
come to the reject port.

Is This Answer Correct ?    23 Yes 2 No

In Join component which record will go to unused port and which will go to reject port ?..

Answer / 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

In Join component which record will go to unused port and which will go to reject port ?..

Answer / gopichinnu

Hi,

In join component suppose if we r using join type as
innerjoin,which records r going to meet the particula type
that records will go to the outport and remaining records
will go to the unused port.

suppose our data contains null values will go to reject
port.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Ab Initio Interview Questions

What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

0 Answers  


What is sort component in abinitio?

0 Answers  


Explain what is sandbox?

0 Answers  


How you can generate surrogate key? How to use in abinitio graph?

2 Answers   IBM, TCL, Torry Harris,


What parallelisms does Abinitio support?

0 Answers  






How to add default rules in the transformer?

0 Answers  


What is .abinitiorc and What it contain?

3 Answers   CSC,


Have you ever encountered an error called “depth not equal”?

0 Answers  


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

2 Answers   IBM, TCL,


what is environment variables and parameters?

1 Answers  


What is the importance of eme in abinitio?

0 Answers  


What is the diff between abinitiorc and .abinitiorc files ?

1 Answers   IBM, Infosys, TCL,


Categories