India | USA jobs - srinimf.jobthread.com

Comments

Post a Comment

Popular posts from this blog

SQL for Quantile Function in Teradata

Image
A Quantile is used to divide rows into a number of categories or grouping of roughly the same number of rows in each group. Quantile Function The percentile is the QUANTILE most commonly used in business. This means that the request is based on a value of 100 for the number of partitions SELECT Product_ID1, Sales_Date1, Daily_Sales1 ,QUANTILE(100, Daily_Sales1 ) AS "Quantile1" FROM Sales_Table WHERE Product_ID1 < 3000 AND Sales_Date1 > 1000930 ; The calculation is percentile for every row in the Sales table on Daily sales.
Read more

12 Frequently Used File Control Commands in BTEQ utility

Image
The below list shows ultra frequently used commands in BTEQ utility. DEFAULTS: Reset all BTEQ format command options to their defaults. This will utilize the default configurations ECHOREQ - Enable the Echo required function in BTEQ returing a copy of each Teradata SQL request and BTEQ command to the standard output stream EXPORT - Open a file with a specific format to transfer information directly from the Teradata database. IMPORT - Open a file with a specific format to import information into Teradata INDICDATA - One of multiple data mode options for data selected from Teradata. The modes are INDICDATAFIELD or RECORD MODE OS - Execute an MS-DOS, PC-DOS or Unix command inside BTEQ QUIET -Limit BTEQ output displays to all error messages and request processing statistics REPEAT - Submit the next request a certain amount of times RUN - Execute Teradata SQL requests and BTEQ commnads directly from a specified run file TSO - Execute an MVS TSO command from inside the BTEQ env...
Read more

Teradata Quick refresher for most popular Utilities

Image
Teradata utilities are very important while working with SQL and in data warehousing projects. The below short and crispy definitions help you can use while attending for interviews or in your day to day work to refresh your Teradata knowledge.  Top Teradata Utilities 1# MultiLoad  Inserts, updates, deletes, or upserts rows in a Teradata table by using the MLOAD command-line utility. It can handle multiple SQL statements in a single operation. You can provide user-defined SQL for complex operations. This stage is best used for bulk updates, deletes, upserts, and complex interface operations. 2# TPump  Inserts, updates, deletes, or upserts rows in a Teradata table using the TPUMP command-line utility. It can do concurrent updates on the same table. It can handle multiple SQL statements in a single operation. You can provide user-defined SQL for complex operations. 3# FastExport  Exports data from a Teradata table by using the FEXP command-line utility. ...
Read more