Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rohitrevo

    EDW - Logically Integrated across multiple DBs v/s Single DB

    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...
  2. rohitrevo

    INDICDATA data file as source input

    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.
  3. rohitrevo

    Automatic Data Generation Tool

    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.
  4. rohitrevo

    Date Difference (Urgent Plz)

    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...
  5. rohitrevo

    Help on Ab Initio products

    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.
  6. rohitrevo

    Pulling Random Records

    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;
  7. rohitrevo

    Pulling Random Records

    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...
  8. rohitrevo

    Pulling Random Records

    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
  9. rohitrevo

    How to use Informatica and Teradata support tools for DW

    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...
  10. rohitrevo

    Multi Dimensional Modelling in Teradata

    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...
  11. rohitrevo

    inserting

    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...
  12. rohitrevo

    BTEQ,Multiload,Fastload

    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.
  13. rohitrevo

    does teradata have exp function

    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

Part and Inventory Search

Back
Top