Blogs

Truncate removes all the rows from a table. Delete with a where clause can delete rows (as specified using where...

Creating the User Group and add the members to the User Group in Cognos Log on to the Cognos connection Go the launch...

Data sets are not static. They are constantly being updated, which can affect the quality of data. Data quality...

Source Analyzer: Step 1: Go to tools menu select source menu select Source analyser files from source menu. Import...

Introduction: In this document, we are going see the flow of query processing and result caching feature in Amazon...

What Is Compression? Compression is a column-level operation that reduces the size of data when it is stored....

Sometimes Tableau will not recognise one or more of the location names in your data. When this happens, those values...

Introduction: HAProxy, which stands for High Availability Proxy. Its most common use is to improve the performance and...

JOINS: Join is used to combine one or more tables, from tables based on condition (Common fields). Joins are divided...

FLAT FILE: A flat file is an ASCII text file which is saved with extension .txt, .csv, etc… Source Analyzer: Step 1:...

While creating flatfile with header line by using session level header command, by default it adds # symbol in header...

Adop Issues: Adop is not to able to detect any valid application tier node entries in the ADOP_VALID_NODES table this...