Skip navigation
Contact Us
805 Views 4 Replies Latest reply: Mar 15, 2013 7:43 AM by Jyotheswar K RSS
Evan Cutler Newbie 10 posts since
Feb 26, 2013
Currently Being Moderated

Feb 27, 2013 10:52 AM

static values for targets...

Greetings,

I am trying to find a way to set static values for targets (ie.  sysdate).

I tried a function trasnformation, but I got a "you don't have an input" error on it.

 

Where do I set values for targets where the values are static:  NULL, SYSDATE, 1, etc...  and I do not need an input link to make them.

 

Thanks,.

  • vasu bhattiprolu Apprentice 83 posts since
    Apr 22, 2012
    Currently Being Moderated
    Feb 28, 2013 1:16 AM (in response to Evan Cutler)
    Re: static values for targets...

    Hi Eculter,

     

    If ur target is flat file then add FileName column to the target in Target designer(The option "ll be there at right side top corner..when u dbl clk the tgt defination).

     

    Pull that port into expression.Now u can add Tgt_name_sysdate to that output port.

     

    However its nt a static value..it changes according to sysdate.

     

     

    Regards,

    Srinivas

  • Ecaterina Buzenchi Novice 33 posts since
    Feb 12, 2013
    Currently Being Moderated
    Mar 14, 2013 7:35 PM (in response to Evan Cutler)
    static values for targets...

    Hi,

     

    You have to options to do this:

    1. set the static values as default values in the table itself
    2. in informatica you can do this in Expressions - just set the port as Output only (no input) and give it the value you need.

     

    I hope this helps.

  • Jyotheswar K Apprentice 204 posts since
    Jul 9, 2012
    Currently Being Moderated
    Mar 15, 2013 12:48 AM (in response to Evan Cutler)
    static values for targets...

    1) you can popualte statis values thru expression transformation in informatica but not function transformation

     

    2) while creating table definition itself you can set default value as sysdate,null for columns u needed. so that default values would get populated when you dont populate any thing thru informatica

     

    Let me know if any of above options work for u

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points