PowerExchange for Lotus Notes User Guide for PowerCenter

10.5.6
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5
- 10.4.0

Back Next

Adding Formula-Based Columns

You can add a column to a source definition that is associated with a Lotus Notes formula. When you enter a Lotus Notes formula, the PowerCenter Integration Service calculates the data in the column after evaluating the formula. If you do not enter a valid formula, no data is retrieved for the column.

In the Source Analyzer, click Sources > Import from Lotus Notes.

The Import Lotus Notes Source dialog box appears.

Select a Lotus Notes source.

The Select Fields dialog box appears.

Click Add Formula Field.

The Edit Column Information dialog box appears.

Enter the column information.

Click Edit Formula.

The Edit Formula dialog box appears.

Enter the formula for the formula-based column, and click OK.

A formula must start with an at sign (@).

The PowerCenter Integration Service writes a message to the session log if you have specified an invalid formula.