Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
LOOK UP..
- Thread starter doove
- Start date
Here are some comparision info. Hope this help.
Connected -
1)Receives input values directly from the pipeline.
2)Can use dynamic or static cache.
3)Cache includes all lookup columns used in the mapping(ie lookup table columns included in the lookup condition and the lookup table columns linked as output ports to other transformations).
4)Can return multiple columns from the same row or insert into the dynamic lookup cache
5)If there no match for the lookup condition returns the default value for all output ports(can update dynamic cache or leave it unchange)
6)If there is a match for the lookup condition returns the value of the lookup conditions for all output ports(can update dynamic cache or leave it unchange)
7)Pass multiple output values to another transformation and link output ports to another transformation
8)Support user defined default values.
Unconnected -
1)Recieves input values from the result of a :LKP expression in another transformation
2)Can only use static cache
3)Cache includes all lookup/output ports in the lookup condition and the lookup/return port.
4)Designate one return port. Return one column for each row.
5)If there's no match for the lookup conditions returns NULL.
6)If there's a match for the lookup conditions returns the resultof the lookup condition into the return port.
7)Pass one output value to another transformation. The lookup/output/return port passes the value to the transformation calling :LKP expression.
8)Does not support user define default value.
Connected -
1)Receives input values directly from the pipeline.
2)Can use dynamic or static cache.
3)Cache includes all lookup columns used in the mapping(ie lookup table columns included in the lookup condition and the lookup table columns linked as output ports to other transformations).
4)Can return multiple columns from the same row or insert into the dynamic lookup cache
5)If there no match for the lookup condition returns the default value for all output ports(can update dynamic cache or leave it unchange)
6)If there is a match for the lookup condition returns the value of the lookup conditions for all output ports(can update dynamic cache or leave it unchange)
7)Pass multiple output values to another transformation and link output ports to another transformation
8)Support user defined default values.
Unconnected -
1)Recieves input values from the result of a :LKP expression in another transformation
2)Can only use static cache
3)Cache includes all lookup/output ports in the lookup condition and the lookup/return port.
4)Designate one return port. Return one column for each row.
5)If there's no match for the lookup conditions returns NULL.
6)If there's a match for the lookup conditions returns the resultof the lookup condition into the return port.
7)Pass one output value to another transformation. The lookup/output/return port passes the value to the transformation calling :LKP expression.
8)Does not support user define default value.
- Status
Similar threads
- Locked
- Question