DW: Teradata Data warehousing Pictorial Diagram

ODS : Operational data source

Teradata Load Server: Where data received from ODS is stored in Teradata load server.

RDBMS: This is the database, which interacts with Tearadata Load server.

Comments

Post a Comment

Popular posts from this blog

3 Types of Access Rights in Teradata

Image
There are 3 types of access rights in Teradata. How these access rights will obtain? Let us see full details. DBC is default user, under it SYSDBA will come, and then other users will come. DBC is super user, it has full powers, and credentials should be Confidential. Implicit rights : Belong to the owners of objects. Owners don't require rows in the DBC.AccessRights table to grant privileges on owned objects. Ownership rights can't be revoked. A parent or owner has the implied right to GRANT privileges over their children. DBC and SysDBA hold implicit roles on all the other databases above. Automatic rights: Happen whenever a CREATE statement is submitted, and new rows are automatically added to the DBC.AccessRights table. When the databases above were created, they automatically received all but four access rights on themselves. Automatic rights are removed with REVOKE or DROP statements. Explicit rights  : are completely controlled by when a user explicitly and ...
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