#DateForumTypeThreadPost
828 Oct 2014 @ 08:19 PDTToolsTopicDoubts regarding MLOAD scriptHi All, I am having a single target table which needs to be updated from 7 different tables which are joined and having aggrgated for a fact columns. The single target table is having a PI which ...
728 Oct 2014 @ 05:59 PDTToolsReplyFLOAD Script throws error "TPT_INFRA: At "select" missing SEMICOL_ in rule: Job Definition Body"Hi fienholz/Dieter, Thanks much for your replies. I created a script containing delete and insert statement which is working fine. The above created script I run using tbuild -f file.txt -v Vari...
627 Oct 2014 @ 11:45 PDTToolsReplyFLOAD Script throws error "TPT_INFRA: At "select" missing SEMICOL_ in rule: Job Definition Body"Hi, I am using 15.0 teradata client I am having doubts regarding FLOAD. We run fload using Cmd eg; C:/FASTLOAD < fld filename; Is it right? I am having a case stmt in the select list, Is case...
526 Oct 2014 @ 11:39 PDTToolsTopicFLOAD Script throws error "TPT_INFRA: At "select" missing SEMICOL_ in rule: Job Definition Body"Hi All, I am having the below sql script from which we need to load the initial data as follows:  It is throwing an error as TPT_INFRA: At "select" missing SEMICOL_ in rule: J...
419 Oct 2014 @ 09:26 PDTToolsReplyUpdating an aggregate table from detail table using MLOAD (multiload) or job.Hi, I wrote the below script as follows: I am using teradata 15 client .Logtable Logtable003; .Logon tpx/uname,pass; .Begin Import Mload  tables tb_c3;  /*target table*/ .Layout...
319 Oct 2014 @ 12:12 PDTToolsReplyUpdating an aggregate table from detail table using MLOAD (multiload) or job.Hi, The secenario is I am having src table as country_Details and target table as CountryMeasure. Below are the columns of tables Country_Details   CountryMeasure PK_Key, &nbs...
218 Oct 2014 @ 08:51 PDTToolsReplyUpdating an aggregate table from detail table using MLOAD (multiload) or job.Hi dnoeth, Thanks for your reply. Can you please explain in detail. I am having a tool generated scrip using tpt which I can update will it work? Is there any documents which give an idea of ma...
118 Oct 2014 @ 02:03 PDTToolsTopicUpdating an aggregate table from detail table using MLOAD (multiload) or job.Hi All, I am new to teradata and done some findings on FLOAD, MLOAD and manually creating a job to load data from 1 table to another. I am able to do FLOAD, mload for loading the data from 1 tabl...