Reject File
Parameters
You
can create user-defined reject file session parameters. Use a reject file
parameter when you want to change the name or location of session reject files
between session runs. Name all reject file session parameters with the prefix
$BadFile, followed by any alphanumeric and underscore characters. All
reject file parameters within a session need to have distinct names. You can
create a reject file parameter for any target in a session. When you define the
parameter in a parameter file, you can reference any directory local to the
PowerCenter Server.
You
can use a user-defined reject file session parameter in either the Reject File
Directory or Reject Filename session property.
Changing
the Reject File Name
You
can use a reject file parameter to change the name of a reject file a session
uses. In the Properties settings of the Mapping tab, enter the reject file
parameter in the Reject Filename field. Then define the parameter in the
parameter file. When the PowerCenter Server runs the session, it locates the
directory listed in the Reject File Directory field and creates the reject file
listed in the parameter file. If the reject file already exists, it appends
rejected data to the existing reject file.
For the reject file name, you create a
session parameter named $BadFileName. In the parameter file, you set
$BadFileName to “FirstRun.bad.” When you registered the PowerCenter Server, you
set $PMBadFileDir for C:/Program Files/Informatica/PowerCenter Server/BadFiles.
When the PowerCenter Server runs the session, it creates the FirstRun.bad file
in the C:/Program Files/Informatica/PowerCenter Server/BadFiles directory.
Changing
the Reject File and Directory
You
can use a reject file parameter to change both the directory and name for
session reject files. When you specify both the reject file and directory in
the Reject Filename field, you need to clear the Reject File Directory field.
The PowerCenter Server concatenates both fields to determine where to find the
indicated reject file.
For
example, you use a database connection parameter to configure a session to
write to different target databases. Instead of having the PowerCenter Server
append rejected data from all sessions to the same reject file, you want to
have a reject file for each target system. In the session, you name the reject
file $BadFileName and clear the Reject File Directory field. In the parameter
file, you set $BadFileName to the reject filename and directory for the target
database used in the session. When you change the database connection parameter
to a different database, you can also change the reject filename and directory.
Alternatively,
you can create a different parameter file for each target system. You can then
use pmcmd to specify which parameter file to use when you start the
session.
No comments:
Post a Comment