0

I am using flat file target in my workflow and populate the file using FileName property.

It works just fine, but also creates another file with just the headers in it.

I want to disable its creation but not sure how to do it. Output filename property in Informatica session

I tried removing Output filename property in the session, but it couldn't be empty.

Guide says that dynamic files are supposed to overwrite the one specified in properties, but it is not happening for some reason.

https://docs.informatica.com/data-integration/powercenter/10-5/designer-guide/mappings/creating-target-files-by-transaction/running-the-session.html

Improve this question
2
  • Hi - what are the names of the two files being created and in which directory (or directories) are they being created? Commented Apr 8, 2024 at 22:07
  • They are created in the same folder, which is specified in the $PMTargetFileDir. First one, has the headers only and the name is what is entered in Output Filename attribute. Second one, has all the data and it is populated in the field FileName in the Target itself. Commented Apr 8, 2024 at 22:14

1 Answer 1

Reset to default
0

Short answer: You can't.

Explanation: Informatica, before starting the data load, ensures the sources and targets are accessible. One of the tasks is to create the target file with the default name. Next, the data load happens - then your desired target file is created. Once job is done, the dummy file persists.

Workaround: add a Command task to your workflow that removes the default file.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thank you for explaining. I was able to implement it as you advised.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.