• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 817
  • Last Modified:

Insert Filename as part of Load in Informatica


I am loading XML Data into an Oracle database table using informatica. We have a column in that table called FILENAME, i need to insert the filename into that column. Is there a way to do this thru informatica.

One XML file might insert many records, so i would need the filename for all those records.

1 Solution
Offhand that sounds like a bad conceptual design, the data content should stand for itself, and not require the filename.  But of course, the simplest concept that comes to mind is to transform the data such that the filename is saved as an additional column in the datafile on every record, and then you can load that into a table so you can store your file name over and over again in denormalized fashion... do you have a data modeler that doesn't want to shoot you for this 3NF violation?  Anyway, I'm in an environment where we use Informatica, and generally I don't see filenames being saved as part of Informatica loads, it might not be such a common thing.
WaqasulhaqAuthor Commented:
NO solution was found

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now