Search results for query: *

We have 3 divisions lets say for discussion purposes A,B and C. B is the Core of the Warehouse since 4 years and now A wants to join in. Should we aim for a single Database to store all the Tables or should we have separate Databases for each division. If we have a single Database, there is a...

You can use FASTEXPORT utility in FORMAT FASTLOAD and MODE INDICATOR. The FastExport can also generate a MLOAD script for you which you can use after basic modifications.

Do u know of any data generation tool(preferably free and Windows based), which will enable us to load data into prebuilt tables. Basically generating test data. We have one SQL Generator, tool but is unix based and takes some time to learn. Please give the URL for downloading such a tool.

Hi Deu Teradata has the facility of doing simple arithmetic sums or subtractions on date functions and it returns number of days as output. Assuming we have a table datetest and we want a list of customers where difference between dtofpay and dtofjoin is greater than 30 days or 1 month. sel...

What is the basic differentiating factor in Engine based ETL tools and Code based ETL tools. Can you please give some examples of ETL products, basically whether they are Engine based or Code based.

I wrongly gave the explanation of RANDOM fn in earlier example. Actually in the sql stmt below a random no between 1 and 100 is generated by the system and if it is less than 30 that row is returned to the user. sel * from t2 where random(1,100)<30;

Hello TheTeraKid In Teradata there is a concept of rowid as in Oracle where in we know that the row has been inserted in which sequence. In TD rows are stored randomly on different AMPs and there is no way to know which one was inserted first except if you put in a time stamp in a record. So...

select * from tablename sample n You can substitute 'n' with the actual number of records you want the sample. Say if you want 5 records and the table name is emp...the sql will be sel * from emp sample 5

In a typical Data Warehousing environment, it is likely that we use ETL tools like Informatica, SAS, etc for extraction and cleansing and then using some Teradata utility like FastLoad or MultiLoad. While the data load from ETL tools like Informatica, SAS is done using ODBC, it is quite slow in...

Most of the databases like SQL Server 7, Oracle 9i, IBM Essbase have a multidimensional engine which allow OLAP analysis. But Teradata V2R4 does not have a multidimensional engine and if we have to make cubes we resort to cube building in OLAP front end tool like Microstrategy and Cognos...

Updating or inserting into an populated table is slower because the if the target table has data, INSERT SELECT operates on a row-by-row basis. The INSERT SELECT operation operates on a block-by-block basis. The performance is optimised when the target table is empty, and has the same PI as the...

Prashanta You will need to add your tdp-id to the login command. It will be .logon tdp-id/acc password : acc This will help you connect to the Teradata database. tdp-id is usually the server name.

A far as I know there is no function to achieve this, but the ** operator can be used. BTEQ -- Enter your DBC/SQL request or BTEQ command: sel 2**2 (FORMAT 'Z(9)'); *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. (2**2) --------- 4