#DateForumTypeThreadPost
1601 Sep 2015 @ 10:03 PDTToolsTopichow to load different files using multiload into different tables.hi, how to load different files using multiload into different tables. File name will contain target table to load  ex: 'target_tablename_timestamp.dat, each file has header. This heade...
1527 Aug 2015 @ 03:11 PDTToolsReplyLoading a teradata table using multiple files sample scripthi, can we write generic mload script to load different files sequentially. Filename are like this: table1_timestamp,table2_timestamp,table3_timestamp,table4_timestamp etc... i have to use singl...
1418 Aug 2015 @ 06:52 PDTToolsReplymload error - glibc detected *** mload: free(): invalid next size (fast): 0x08171308Hello Dieter, Please advice me on this error.   Regards Rams
1317 Aug 2015 @ 11:25 PDTToolsTopicmload error - glibc detected *** mload: free(): invalid next size (fast): 0x08171308hi, when i execute the mload script through informatica  i am getting the following error message.   MDM DNB Mload Address,Principal,Events tables      ==========...
1210 Aug 2015 @ 07:44 PDTDatabaseReplyutf8TO16 : why is it Latin to unicode conversion function when utf8 itself is unicode encoding?TD 14.10
1107 Aug 2015 @ 02:06 PDTDatabaseReplyutf8TO16 : why is it Latin to unicode conversion function when utf8 itself is unicode encoding?Thanks for you inputs, tried with this option. Data looks okay. have to validate the data. SEL TRANSLATE (COL1 USING UNICODE_TO_KANJI1_KANJISJIS WITH ERROR) AS COL1 FROM (...
1007 Aug 2015 @ 07:09 PDTDatabaseReplyutf8TO16 : why is it Latin to unicode conversion function when utf8 itself is unicode encoding?Dieter, I am connecting to SQLA through ODBC with the session character set UTF8, now i have to write a query to export the data from session character set to another session character set (LATIN1...
905 Aug 2015 @ 12:14 PDTDatabaseReplyutf8TO16 : why is it Latin to unicode conversion function when utf8 itself is unicode encoding?Hi Dieter, can you please help in converting data from UTF8 to LATIN1_0A or ISO8859_1 tried using this below query but i am getting error the string contains untranslatable character. In the same...
805 Aug 2015 @ 09:09 PDTDatabaseTopichow to convert UTF8 Codeset to ISO 8859 codeset conversionHi, want to conver the codset of the col1 to iso 8899 codeset SEL CASE         WHEN DB.COL1 IS NOT NULL THEN  ' ' || DB.COL1    &nb...
718 Aug 2013 @ 09:33 PDTDatabaseReplyquery on CSUMHi Dieter, fact table is having mesures with per day bookings.... the business requirement is to find out the number of bookings happed as off that day.... in between some of the days may not have...
618 Aug 2013 @ 04:16 PDTDatabaseReplyquery on CSUMthe minimum date is the first(intial) transaction of the each name and Maxdate is current date \ system date of each person i.e as of today....   i tried using expand ... clause but iam gett...
518 Aug 2013 @ 03:17 PDTDatabaseReplyquery on CSUMmindate  may be same or it may be different for each name......
418 Aug 2013 @ 01:36 PDTDatabaseReplyquery on CSUMHi Dieter, 13.10 version we are using.   Regards, Ramaiah
317 Aug 2013 @ 03:14 PDTDatabaseReplyquery on CSUMSEL t1.name, t2.calendar_date FROM (SEL name FROM hbarch.ram GROUP BY 1) AS t1, sys_calendar.Calendar AS t2 WHERE t2.calendar_date NOT IN (SEL tran_date FROM hbarch.ram WHERE name = t1.name) AND...
217 Aug 2013 @ 03:14 PDTDatabaseReplyquery on CSUMHi Dieter,   We are trying to find the missing dates from the source table with the sys calendar date. the query is like below.   SEL NAME, MEASURE, ...
117 Aug 2013 @ 01:30 PDTDatabaseReplyquery on CSUMThank you dietier... but my requirement is not this...   I want to get the cumulative sum for the missing dates in the source table ..... example... In the above source table i do not have...