Nulls appear for business key columns on SCD Type1 update
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Wed Aug 29, 2007 1:33 am
- Location: Bangalore
- Contact:
Nulls appear for business key columns on SCD Type1 update
Hi,
I am using SCD stage to do type 1 updates on a particular table.The business key field is of type varchar. When changes on the attribute takes place instead of update a new row is inserted but with business key value NULL.
I tried changing the datatype from varchar to integer (since value were compatible for datatype change) and the type1 update was successful. but now i have a table with values that cannot be integer and I cannot find any workaround.
Can anyone help?
Thanks in advance.
Regards
I am using SCD stage to do type 1 updates on a particular table.The business key field is of type varchar. When changes on the attribute takes place instead of update a new row is inserted but with business key value NULL.
I tried changing the datatype from varchar to integer (since value were compatible for datatype change) and the type1 update was successful. but now i have a table with values that cannot be integer and I cannot find any workaround.
Can anyone help?
Thanks in advance.
Regards
Rudresh Eswarappa
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I wonder if this is related to the known bug in which range lookups work for numeric data types but not for string data types?
Alas I can't help with a solution.
Alas I can't help with a solution.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 21
- Joined: Wed Aug 29, 2007 1:33 am
- Location: Bangalore
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: