 Related Questions Latest Answer : FSLDM --> Financial Services Logical Data Model (FS-LDM). Its a Teradata standard product for Financial Sector (Specifically for Banks). It can be customized based on the user requirements.STAR SCHEMA --> It is a relational database ... Read Answers (3) | Asked by : sathish Latest Answer : As the name suggests Fasload is faster than multiload, and whenever required to load an empty table fastload should be preferred.However, Fastload has some limitations.To perform Fload:1. Target table must be empty2. Fload performs inserts only (no updates)3. ... Read Answers (3) | Asked by : Alok Das After creating tables dynamically in the Teardata, where is the GRANT table option usually done ? When tables are newly created, what is the default role and what the default privileges which get assigned ? Read Answers (2) | Asked by : Abhijit Jagtap Global Temporary tables (GTT) -1. When they are created, its definition goes into Data Dictionary.2. When materialized data goes in temp space.3. thats why, data is active upto the session ends, and definition Latest Answer : In addition to the Shilpa's answer,If you are using volatile table,you can not put the default values on column level ( while creating table ) ... How many error tables are there in fload and what are their significance/use?Can we see the data of error tables?How many error tables are their in mload and what is there use?When mload job fails, can Latest Answer : Ideally, there are 2 error tables in Fload. These table contains the details about the data parcel from source to the target table. We can view the data in error table.It has below detailsErrorCode, ErrorFieldName, and DataParcel ... There are 2 tables, table A with 10 million records, table B has 100 million records, now we are joining both tables, when we seen Explain Plan the plan showing TD will took the table A and it will redistributes Latest Answer : Teradata is smart enough to decide when to redistribute and when to copy....It compares the tables. Are they comparable? or one is big as compared to the other?Based on simple logic it decides whether to distribute the smaller table on all the AMPs or ... What are set tables and multiset tables in Teradata?Explain with an appropriate example? Latest Answer : Set tables doesnt accept exact duplicate records to be inserted in the table. whereas multiset do. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
