If you are using flat file as a target, you may encounter a problem which adds a # symbol to the header as shown in the image below:
To resolve this issue, please follow one of the methods explained below:
Remove ‘#’ by using Informatica session level property.
Remember that this option is available only from Informatica 9.1 HotFix 4 or
later. Earlier versions of Informatica users can follow method 2.
1. In Informatica workflow manager, Go to Session -> Edit -> Config Object.
2. Go to Custom Properties under Advanced section.
3. Add the below values in Custom Properties.
- Attribute: RemoveOutputHeaderHash
- Value: Yes
2. For earlier
version of Informatica (9.1 HotFix 3 or earlier versions) users:
Session property mentioned above is not available In earlier
version of Informatica PowerCenter. Here is the workaround:
1.
In Informatica workflow manager, Go to Session
-> Edit ->Mapping.2. Select your target in left pane.
3. Change the Attribute and its value as mentioned below in Properties section.
- Header Options: Use header command output
- Header Command: Give command according to your requirement (eg. ECHO EMPLOYEE_ID, EMPLOYEE_NAME, SALARY)
3. For Linux/Unix based Informatica users (using
command task):
Linux and Unix users
can remove ‘#’ symbol from target flat file header by following these steps:
1.
Create a Command Task and edit the task.2. Go to command tab and add the below commands:
- Name: RemoveHashSymbol (for example only, you can name anything)
- Command: sed ‘s/#//’ EMPLOYEE_SALARY.csv (your target file name)
- Note:- sed is the replace command, 's' denotes substitution operation, # is the search pattern and no character present between // is the replacement string. This command removes # symbol from first occurrence of every line.
3. Add this command task after the session task and execute the workflow.
4. Session creates the target with ‘#’ symbol in the header and command task will replace it by executing sed command.
0 comments:
Post a Comment