Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: wilkens.dietmarHow to customise
date format in LTW?
I�m quite new to working with application �Lavastorm Transaction Warehouse�, LTW.
The LTW Ref Guide is in front of me, no worries. We use LTW 3.4.5.029.
I need to create readers for csv based event records in LTW. I try to configure a �User Defined Reader� for it.
Incoming time stamp format looks like:
YYYY/MM/DD-HH-Mi-SS.SS
My LTW GUI does not provide a ISO 8601 format under �Read Format� for dates. Disappointing. Probably I�m not the first to find it�. Performance is no issue in our case, only a few files per day. And I prefer not to create some weird script based workaround.
Idea:
I need to create a matching time format in LTW. Some updates in the database should do it, I assume. But where and how?
-
Can you please point me to the tables (or GUI) where I can define a matching date format?
- What solutions are possible to get such a time stamp format implemented within LTW?
Any help welcome.
Dietmar Wilkens, Revenue Assurance, Kabel Deutschland (in Germany)