Home » Developer & Programmer » Warehouse Builder » Assign constant value for one column at target table (10.2.0.1)
Assign constant value for one column at target table [message #302727] Tue, 26 February 2008 18:16 Go to next message
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
Re: Assign constant value for one column at target table [message #303608 is a reply to message #302727] Sat, 01 March 2008 01:53 Go to previous messageGo to next message
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
Re: Assign constant value for one column at target table [message #305433 is a reply to message #303608] Mon, 10 March 2008 14:13 Go to previous messageGo to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
can you explain bit more on map transformation.

which transformation i have to use.
icon8.gif  Re: Assign constant value for one column at target table [message #306052 is a reply to message #305433] Wed, 12 March 2008 12:26 Go to previous message
skumar.dba
Messages: 82
Registered: October 2007
Member
skumar.dba wrote on Mon, 10 March 2008 14:13
can you explain bit more on map transformation.

which transformation i have to use.

--

can any one explain this topic bit more?
Previous Topic: not able to open repository browser
Next Topic: ORA-00439: feature not enabled: Materialized view rewrite
Goto Forum:
  


Current Time: Wed Dec 07 14:51:15 CST 2016

Total time taken to generate the page: 0.09849 seconds