 Related Questions è Transactions take a matter of seconds or less.è Many transactions involve a small amount of data. Latest Answer : OLTP is typified by a small number of rows (or records) or a few of many possible tables being accessed in a matter of seconds or less. Very little I/O processing is required to complete the transaction. For eg.
1. This type of transaction takes place ... operational data stores Latest Answer : ODS=>Operational Data SourceCheers,Sithu ... In which phase of the Active Data Warehouse evolution do you use data to determine what will happen? In which phase of the Active Data Warehouse evolution do you use data to determine what will happen? analytical modeling è operational data storeè logical data mart Latest Answer : 1- Logical Data Mart Repository2- Provides a single version of the truth ... How can we build data marts from FSLDM. is there any standard approach for this? Is FSLDM supports place holder for aggregated data? Read Answers (1) | Asked by : Prabakaran What is cliques? What is Vdisk and how it will communicate with physical data storage at the time of What is cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP ? 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 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
