What is concurrency transparency
Write down a short note on the term concurrency transparency?
Expert
Concurrency transparency is where each and every transaction in a distributed database is treated as when it is the only one in the system. Thus when several transactions are running at one time, the outcomes will be the same as when each and every transaction was run in sequential order. The transaction manager assists to provide concurrency control. The three methods that might be used are versioning, locking, and timestamping.
Briefly describe the foreign key columns in dimension table and fact table?
Explain the various types of stages?
Write about the term Attribute, Entity and Relationship?
Explain the term Vdisk and how this will communicate along with physical data storage at the time of data retrieval by AMP?
Elucidate how many kinds of dimensions are accessible in the Informatica?
Can we have a report with several data providers?
Does System development life cycle changes when you use Teradata in place of Oracle?
Describe briefly the alternative terminology which is employed in the relational model?
What is the repository?
Describes the examples of EXPLAIN in valid teradata database.
18,76,764
1941322 Asked
3,689
Active Tutors
1412717
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!