OraFAQ Forum: Data Integration » Assign constant value for one column at target table

Home » Developer & Programmer » Data Integration » Assign constant value for one column at target table (10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Assign constant value for one column at target table [message #302727]

Tue, 26 February 2008 18:16

pavan27
Messages: 50
Registered: December 2006
Location: bangalore

Member

Hi,

i have two problems now. at my target table i have a column called data_source_id.
it should you always 1(value). how do i assign to constant value to this column.

2) i have one more column called etl_proc_id at target table. when i run etl process this column is update by one. means if i run etl process 10 times the value for this column should be 10.

can any one give me logic. how i can do this tasks

Regards,
kumar

Report message to a moderator

Re: Assign constant value for one column at target table [message #303608 is a reply to message #302727]

Sat, 01 March 2008 01:53

alaa_abdu
Messages: 3
Registered: February 2008
Location: saudi arabia

Junior Member

Hi Pavan27

1- for the first problem , you can assign Constant By dropping Constant icon from the Menu , add new constant and assign its value according to the value you want it
eg. Create new constant > constant name C_source_id > expreseeion value 'Billing System'

2- for the second problem
you can do this in many ways

* you can create a map transformation to read the old value according to the primary key and calculate the result .

* you can leave it without update and do a post map to update this column according to the "old value +1 "

hope this helps u

Report message to a moderator