My Source Data:
ID SOURCE_TS
230 2012-05-31 15:13:32.6540000
230 2012-05-31 15:13:52.1540000
Reference Data:
REF_ID REF_TS
230 2012-03-22 07:19:37.1490000
230 2012-05-31 15:13:32.6540000
230 2012-05-31 15:13:52.1540000
Getting Error:-
Ignoring duplicate entry at table record 3; no further warnings will be issued for this table
Lookup Fails on Timestamp with MicorSeconds.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
Re: Lookup Fails on Timestamp with MicorSeconds.
As noted this is not error but just a warning and looking at the warning it is clear that on the reference link the column is defined as Timestamp witthout the microseconds extensionsynsog wrote:Getting Error:-
Ignoring duplicate entry at table record 3; no further warnings will be issued for this table
- Zulfi
Re: Lookup Fails on Timestamp with MicorSeconds.
Getting Error:-
Ignoring duplicate entry at table record 3; no further warnings will be issued for this table
Why above warning will come and what need to do to supress that one
Thanks
Ignoring duplicate entry at table record 3; no further warnings will be issued for this table
Why above warning will come and what need to do to supress that one
Thanks
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
Re: Lookup Fails on Timestamp with MicorSeconds.
Look up will generate the warning if there are duplicate values over the key columns, in your case there are no duplicates if the microseconds are considered.
It is not advisable to look for means of how to suppress warnings rather approach with a resolution to fix the warnings.
you have two choices:
1) Select the extended "microseconds" option in the reference link
2) Select "Multiple rows returned from link" option in the look up - Beware this would make your look up work like a join stage (inner join)
It is not advisable to look for means of how to suppress warnings rather approach with a resolution to fix the warnings.
you have two choices:
1) Select the extended "microseconds" option in the reference link
2) Select "Multiple rows returned from link" option in the look up - Beware this would make your look up work like a join stage (inner join)
- Zulfi