by ablessquare | Jul 26, 2019 | Blogs
Truncate removes all the rows from a table. Delete with a where clause can delete rows (as specified using where clause) from a table. Drop will delete a table from the database. Drop and Truncate are DDL commands, whereas DELETE is a DML command. Please find the...
by ablessquare | Jul 17, 2019 | Blogs
Creating the User Group and add the members to the User Group in Cognos Log on to the Cognos connection Go the launch click on Cognos Administration> Security Click on User Groups and Roles Click on the Cognos folder where we need to Create the User Group as shown...
by ablessquare | Jul 17, 2019 | Blogs
Data sets are not static. They are constantly being updated, which can affect the quality of data. Data quality monitoring helps to resolve data issues quickly and also provides quality data. There are various ways we can resolve data issues in Tableau without...
by ablessquare | Jul 10, 2019 | Blogs
Source Analyzer: Step 1: Go to tools menu select source menu select Source analyser files from source menu. Import source data from Database. Target: Step 2: Go to tools menu select target menu select target files from target menu. Import Target data from file (.csv...
by ablessquare | Jun 28, 2019 | Blogs
Introduction: In this document, we are going see the flow of query processing and result caching feature in Amazon Redshift. The Query Planning And Execution Workflow: The leader node receives the query and parses the SQL. The parser produces an initial query tree...
