Use of Unused port in Join component.

What is the use of the unused port in the join component? We have reject port. Difference between the reject port & unused port?

Emanisreddy
Profile Answers by Emanisreddy Questions by Emanisreddy
Apr 17th, 2012
3
7848

Questions by Emanisreddy answers by Emanisreddy

Data Warehousing

Answer

Showing Answers 1 - 3 of 3 Answers

anshuman trivedi

Mar 3rd, 2013

Hi,
Answer of question is as following.
1)Reject Port:it will contain all the rejected record,here rejection does not means those records which does not follow the join condition,here comes those record which have data discrepancy.

2)UNUSED port:It have all those records which does not follow the join condition.

Now there will be as many unused port as many input you want to join.
If you have two input to join then there will be two unused port.
unused 0 having data related to the input one and so on.

Regards,
Anshuman