CRT.TDS Flashcards
1
Q
Table to check Source system trade feeds
A
Core.ETS.TradeFeeds
> BusDate = ‘20140410’
> SourceSystemName = ‘DEVONFOREX-TOKYO’
2
Q
Name Mongo PDN & DR machines
A
PDN - ldnpsr37899
DR - gbrcsr11196
3
Q
Name TDS PDN machine
A
ldnpsm028853
4
Q
Table to check the feed cutoff
A
DECLARE @ts DATETIME
SELECT @ts = MAX(crtdatetime) FROM core.dbo.feedset
5
Q
how to do trade cutoff
A
EXEC Core.ets.GetTradeFeedCutoff @Timestamp = ‘2014-03-27T18:34:51’, @BusDate = ‘27/03/2014’