sithusithu

 Profile Answers by sithusithu 

• Jan 20th, 2006

 

 

Master and detail source

Type of join

Condition of the join

the Joiner transformation supports the following join types, which you set in the Properties tab:

• Normal (Default)
• Master Outer
• Detail Outer
• Full Outer

Cheers,

Sithu

ORAINFO

 Profile Answers by ORAINFO 

• Nov 20th, 2008

 

There are number of properties that you use to configure a joiner
transformation are:

1) CASE SENSITIVE STRING COMPARISON: To join the string based on the case
sensitive basis.

2) WORKING DIRECTORY: Where to create the caches.

3) JOIN CONDITION : Like join on a.s =v.n

4) JOIN TYPE: (Normal or master or detail or full)

5) NULL ORDERING IN MASTER

6) NULL ORDERING IN DETAIL

7) TRACING LEVEL: Level of detail about the operations.

8) INDEX CACHE: Store group value of the input if any.

9) DATA CACHE: Store value of each row of data.

10) SORTED INPUT: Check box will be there and will have to check it if the
input to the joiner is sorted.

11) TRANSFORMATION SCOPE: The data to taken into consideration. (transcation
or all input) transaction if it depends only on the processed rows while look up
if it depends on other data when it processes a row. Ex-joiner using the same
source in the pipeline so data is within the scope so transaction. using a
lookup so it depends on other data or if dynamic cache is enabled it has to
process on the other incoming data so will have to go for all input.