problem while reading from teradata database
Posted: Tue Nov 09, 2010 10:12 am
Hi,
Source:
Stage :Teradata entreprise stage source_column datatype: sql type :Timestamp, extended :microseconds, nullable:no
Target: :
Teradata entreprise stage, target_column datatype: timestampsource_column datatype: sql type :Timestamp, extended :microseconds, nullable:yes
I am having 4 such timestamp columns.out of which 3 columns are 'nullable' in source. all the four columns are 'nonnullable' in target
whiile running , i am getting the following warning multiple times
Note that 'crept_contact_diary' in the warning message is my source teradata entreprise stage
kindly help me to get rid of this warning
Thanks in advance,
Raja R P
Source:
Stage :Teradata entreprise stage source_column datatype: sql type :Timestamp, extended :microseconds, nullable:no
Target: :
Teradata entreprise stage, target_column datatype: timestampsource_column datatype: sql type :Timestamp, extended :microseconds, nullable:yes
I am having 4 such timestamp columns.out of which 3 columns are 'nullable' in source. all the four columns are 'nonnullable' in target
whiile running , i am getting the following warning multiple times
Code: Select all
crept_contact_diary,1: Data string ' ' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss.6': an integer was expected to match tag %yyyy.
kindly help me to get rid of this warning
Thanks in advance,
Raja R P