SAS Data Integration Studio can
automatically propagate columns from one transformation to another.
However, this propagation is not necessarily possible in template
jobs that use 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 a final detail table. 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 final detail 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 detail table.