How to Customize Your Target Flat File Column Headings
To
create flat file using a Power Center workflow, it creates the file with target
table port name as the column headings, But you might need to change the column
heading, which make more meaning to the column data before it can be given to
the business users. Here in this article we will see how we can customize the
target file column header.
As the first step lets Build the
mapping which creates the flat file, like we have it in below image.
Now lets Create the workflow, Open the session in edit mode and navigate to the mapping tab and to the target properties. What we see below is the the default configuration.
Change the configuration as it is
in the below picture to customize the target column heading.
Note:
You will have to change the "Header Command" based on your operation
system and the column heading you need.
You are all done with the required
configuration for Target File Column Customization and here is the output file
looks like
No comments:
Post a Comment