Can we have multiple specifications for same source column in the Modify Stage? coz i tried that and i get the error message that it was already 'bound'
I have a requirement where the source column is nullable and i need to change its nullability via this modify stage, but i also need to change datatype..do i need 2 modify stages or can i do 2 specifications for this column in one stage..?
pls advise
MOdify Stage: Multiple specifications for same source column
Moderators: chulett, rschirm, roy
Re: MOdify Stage: Multiple specifications for same source co
You can only have one specification for a source column.jreddy wrote:Can we have multiple specifications for same source column in the Modify Stage? coz i tried that and i get the error message that it was already 'bound'
I have a requirement where the source column is nullable and i need to change its nullability via this modify stage, but i also need to change datatype..do i need 2 modify stages or can i do 2 specifications for this column in one stage..?
pls advise
However you can do both the modifications that you want in the same specification.
You can make a specification like
Code: Select all
new_field:nullable string[max=10] = conversion_of_old_field
Thanks JeroenDmt
Here's what i needed to do - source is nullable with datatype of varchar2(8) - basically its length is defined as 8, but holds data with only 2 chars length
my target has this column defined as NOT NULL and varchar2(2)
In the modify stage, i created a new column with datatype varchar2(2) and nullability NOT NULL and i specified
<new_column_name>=handle_null(<old_column_name>,"NO")
But the warning message says
When binding input interface field "SC" to field "SC_NEW": Implicit conversion from source type "string[max=8]" to result type "string[max=2]": Possible truncation of variable length string.
How should i get rid of this warning.. thanks
Here's what i needed to do - source is nullable with datatype of varchar2(8) - basically its length is defined as 8, but holds data with only 2 chars length
my target has this column defined as NOT NULL and varchar2(2)
In the modify stage, i created a new column with datatype varchar2(2) and nullability NOT NULL and i specified
<new_column_name>=handle_null(<old_column_name>,"NO")
But the warning message says
When binding input interface field "SC" to field "SC_NEW": Implicit conversion from source type "string[max=8]" to result type "string[max=2]": Possible truncation of variable length string.
How should i get rid of this warning.. thanks
Actually, i just tried a CAST(column_name as varchar2(2)) when reading the source and set the metadata as varchar2(2) right from the beginning and avoided the use of modify for modifying datatype.. still going to use it for modifying the nullability..
this workaround worked for me, but i'd like to know (if you have time) if i can still use Modify to do both nullability and datatype modification, as in my case... thanks
this workaround worked for me, but i'd like to know (if you have time) if i can still use Modify to do both nullability and datatype modification, as in my case... thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: