Insert Filename as part of Load in Informatica

Posted on 2009-12-22
Last Modified: 2012-05-08

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.

Question by:Waqasulhaq
    LVL 8

    Accepted 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.

    Author Closing Comment

    NO solution was found

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now