SAS Data Integration Studio can automatically propagate
columns from one transformation to another. However, this propagation
is not necessarily possible in the Basic (Multiple) Web Log Template Job because
of the use of the Loop and Loop End transformations.
Therefore,
any user columns that are created in the Clickstream Log or Clickstream
Parse transformation in the first loop do not automatically appear
in the final detail output table. Two approaches to manual propagation
are available. Use the first approach if the user column has not been
defined yet, and use the second if it has.
The first
approach recommends that users add a user column that has not been
previously defined to the final destination table, which is typically
a permanent table such as MULTI_DDS_OUTPUT. Then, you can import the
column into the other locations where it is required. If you add the
column to the final destination table, you must import the column
into the appropriate locations in the job.
For example, you might need to perform the following tasks:
-
Open the
Columns tab in the properties window for a PARAM_PARSE_RESULTS table in
a job. Then import the desired column from the MULTI_DDS_OUTPUT table.
The column is automatically propagated to the Clickstream Sessionize
target.
-
Import the column into the
User Columns tab in Clickstream Log or Clickstream Parse
transformations in the first loop in the job. Then, click the
Target Table tab in Clickstream Parse to add the column
to the target table.
Perform the following steps to manually propagate a user column that
has already been defined in the first loop and is output from the
Clickstream Parse transformation:
-
Add the
column to the PARAM_PARSE_RESULTS table in the second loop, which
is an input to the Clickstream Sessionize transformation. Once added,
it is automatically propagated to the target table of this transformation.
-
Add the
column to the final MULTI_DDS_OUTPUT table.