#DateForumTypeThreadPost
401 Jul 2009 @ 05:34 PDTToolsReplySQL assistant vs BTEQHi, you can execute SQL scripts using BTEQ this way:1st file (BTEQ.bat) contains:---------------------------"c:\Program Files\NCR\Teradata Client\bin\bteq.exe" ( "SCRIPT_NAME.txt" ) "SCRIPT_NAME.lo...
324 Jun 2009 @ 06:45 PDTUDAReplyUpdate Strategy with TeradataI also think, that it does not matter if target table in Teradata has UPI or NUPI, what matters is how you set PK in target definition in Informatica.
224 Jun 2009 @ 05:53 PDTUDAReplyAggregates in TeradataYou have Daily table which has UPI (id, date_valid).You have Code table which has UPI (period_id).You have view (or another Daily table if you wish to keep the history) with "flag columns" for each...
124 Jun 2009 @ 05:06 PDTDatabaseReplyBeginning Teradata userTeradata Documentation can be downloaded for free here http://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy.cfm?page=Teradata%20Database . You are looking for SQL Reference: Functions and ...