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!

joiner transformation

Status
Not open for further replies.

kpmINFO

IS-IT--Management
Apr 1, 2004
77
US
Can I use a joiner transformation any where within a mapping.
Suppose if I have two expression transformation and each of expression transformation has a common port ID, can I join these two transformations using a joiner transformation .
I am under the impression that joiner transformation should always follow source qualifier, please correct me if I am wrong.
 
You are totally wrong... :)

The bottomline is, that the place in the mapping can be anywhere, but you cannot join data that is 'split' earlier in the mapping. INFA will not allow that.

A source qualifier is (among others) a special kind of 'extended' joiner that allows more manipulation, like override SQL statements, distinct clauses etc.

I would suggest taking some formal training......



T. Blom
Information analyst
tbl@shimano-eu.com
 
In INFA 7.x you can use Joiner Trans to join data originating from same source...

Sri
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top