Database Reference
In-Depth Information
Figure 3.19
Unique member names.
Figure 3.20
Text-derived unique member names.
The resulting member set (when sampled) looks like Figure 3.19.
While the preceding example leverages a relational connection, it is important to
note that many functions (especially the string manipulation functions) also work with
text files. For example, this function performs a similar substring and concatenation on
a text file source:
'substr'( connection : \'SampleText'::'TBC_PRODUCTDIM.TXT'.'SKU_
ALIAS', 1, 4 ) || "-" || connection : \'SampleText'::'TBC_
PRODUCTDIM.TXT'.'SKU'
The resulting sample can be seen in Figure 3.20.
Note:
Since this is a text source, you cannot leverage functions to work across tables
because the text mini-schema does not allow for joins across flat files.
