by ablessquare | Mar 29, 2019 | Blogs
Introduction: The In-Memory Column Store (IM column store) allows users to store Oracle Database objects like columns, tables, partitions and materialized views in memory in a columnar format, rather than the typical row format. It is mainly used for analytic queries...
by ablessquare | Mar 27, 2019 | Blogs
Create a cluster in AWS Download and install one of the following, depending on the system architecture of your SQL client tool or application: 32-bit:https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.4.1001/AmazonRedshiftODBC32-1.4.4.1001.msi (The name for...
by ablessquare | Mar 26, 2019 | Blogs
Elastic Block Store- EBS Volume Types 4 volume types SSD – Solid State Drive HDD – Hard Disk Drive General Purpose – gp2 Provisioned IOPS – io1 Throughput Optimized HDD – st1 Cold HDD – sc1 Size 1GB – 16TB Size 4GB – 16TB Size 4GB – 16TB Size 4GB – 16TB Max IOPS 16000...
by ablessquare | Mar 21, 2019 | Blogs
Source Analyzer: Go to tools menu >select Source Analyzer as shown in below screenshot. Go to sources (from menu bar) To import the source tables from database. As shown in below screenshot. Provide the user ID and Password to connect to the DB and to import...
by ablessquare | Mar 11, 2019 | Blogs
Introduction FileMaker Pro is a cross-platform relational database application from FileMaker Inc., a subsidiary of Apple Inc. It integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by...
