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

Order of Evaluation of Parameters

2 Answers  


how can you convert 3 way to 7way partitioning in abinitio?

4 Answers  


what is meant by fancing in abinitio ?

3 Answers  


What is the DynamicScriptGeneration and what is the Use?

2 Answers  


what is the difference between the .dbc and .cfg extensions and give any clear information ?

4 Answers   Cognizant,


What are the functions of the replicate and dedup component?

0 Answers  


Explain PDL with an example?

0 Answers  


What metadata importer can do in ab initio?

0 Answers  


What is broadcasting and replicate?

0 Answers  


You can ask about different vector functions. How to use in abinitio graph?

0 Answers   IBM, TCL,


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

2 Answers   IBM, TCL, Torry Harris,


Explain the methods to improve performance of a graph?

0 Answers  


Categories