Hi,
I have a table which has a date column which can have a null value.
How do I use the modify stage to handle this the timestamp field.
and
regards,
varsha
problem with handling nulls with timestamp field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Thu Mar 11, 2004 10:32 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the transitional definition don't specify that the target column is nullable, and handle the incoming null so that it is replaced with a default value (or dropped).
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: 48
- Joined: Thu Mar 11, 2004 10:32 pm
Eloborating on this I have read it as a timestamp field in datastage and handled it in a transformer, but the transformer slows the performance soray.wurlod wrote:In the transitional definition don't specify that the target column is nullable, and handle the incoming null so that it is replaced with a default value (or dropped).
I wanted to know how I could use modify stage to handle it, which I am unable to handle