Wednesday, May 6, 2009

Neat trick in Informatica

I just did something by error, and ended up learning a little trick.

You can easily make a source a target, and vice-versa.

Click on the Target Analyzer window in Designer, and then from navigator, open the Source folder. Drag a source into the target window.

BAM!

The source is now a target.

Reverse to make a target a source. Easy. That's a pretty nifty little trick.


This also works easily if you want to copy code from development to production. Just open the mapping analyzer window, and drag it from whatever folder you're copying from into it. This way, you don't have to scroooooll all the way down to where you want to place it. Much easier.

1 comment:

  1. Hi,
    The source to target functionality has been around forever. It was Informatica 101 even in 2000. The target to source is fairly recent. Earlier we used to have to export to XML and import. As far as copying to production, that is "bad practice" and their is a problem with your security setup unless you are the administrator. Deployment to prod is better via deployment groups. I am guessing you already know about the difference between a connected and an open folder.

    Regards,

    Sanjay

    ReplyDelete