618 Feb 2016 @ 07:54 PSTTeradata ApplicationsReplyLinking/Joining Different Databases in TeradataThanks Fred for the input. Is there any specific reason that Teradata is not providing this TD to TD linked server by default. As in other DBMS like SQL server this feature helps to communicate bet...
517 Feb 2016 @ 12:29 PSTToolsReplyTPT - Delimited Data Parsing error: Invalid multi-byte characterWhy don't you use the OS operator in TPT script along with SED command to replace the character with some meaning ful character. Just need to add one more step and can parse the file.
417 Feb 2016 @ 12:23 PSTToolsReplyBTEQ TPTIf both are in same system then using MERGE-INTO could also be an option which will allow to have join index and do operation at block level. In TPT that can be implemented using DDL operator.
317 Feb 2016 @ 12:16 PSTTeradata ApplicationsReplyLinking/Joining Different Databases in TeradataI have successfully create the Foreign Server between TD and TD but not able to select data: get error "Server object not associated with operator". then I tried to add IMPORT clause(sysl...
213 Jan 2016 @ 11:34 PSTDatabaseReplyView based on two tables only insert/update trigger can resolve this issue. Or you have to make as part of ETL job. MERGE-INTO code need to be executed as ETL job. It can't be triggered automatically.  
113 Jan 2016 @ 10:55 PSTDatabaseReplyOLAP functionsOLAP functions are most used for order analytical and data mining purpose, where order of row matters. For example: to calculate running sum of inventory.