-
DB2 11- Advanced Featutres
CPU reductions and performance improvements for certain OLTP, heavy insert, select query workloads, and when running queries against compressed tables. Improved data sharing performance and efficiency. Improved utility performance and additional zIIP eligible workload. Cost-effective archiving of warm and cold data with easy access to both within a single query Intelligent… Read More ⇢
-
Mainframe SyncSort: How to Use Learn Today
SyncSort for z/OS is a high-performance sort/merge/copy utility designed to exploit the advanced facilities of the z/OS operating system and zSeries computers. SyncSort for z/OS also supports the OS/390 operating system and S/390 and compatible computers. SyncSort is used in over fifty countries and is the most frequently installed third-party software product on… Read More ⇢
-
Real Questions on Informatica Repository and client Applications
Services: Integration Service – conducts and implements the ETL logic Repository Service – manages connectivity to the metadata repositories, where mapping and workflow definitions are saved Repository Service Process – retrieves, inserts and updates repository metadata. It is a multi-threaded process. Repository – a database which contains the ETL metadata Client… Read More ⇢
-
Exclusive 3 Types of Slowly Changing Dimension
There are 3 types of dimensions that being used in data warehousing projects. These are called Type1, Type2 and Type3 dimensions. Each one has its own purpose. SCD Type 2 is most popular in data warehousing projects. Read More ⇢
-
Hadoop Integration With Mainframe Here is Useful Story
Hadoop Integration with Mainframe. Latest development, which helps to get great insights with the Date lying in Mainframe. Read More ⇢
-
Life Cycle of Data Processing: Handy Flowchart
The complete life cycle of data science for all developers. Read More ⇢
-
DB2: What is Atomic in SQL Query
Use Atomic to insert multiple rows at a time into Table. Explained SQL query to use in Db2. Read More ⇢
-
How to Invoke a DB2 Stored Procedure in Mainframe
We can implement stored procedures for DB2 for z/OS including C, C++, COBOL, z/OS Assembler, PL/I, REXX, SQL Procedures language (both external and native), and Java. The parameters required to Store procedures we define in the Linkage section. Nesting Stored Procedure: When one stored procedure calls another stored procedure, it is referred to as… Read More ⇢
-
10 Top DB2 SQL Common Mistakes
DB2 is popularly use database in mainframe. Developing DB2 applications that show highest perforce is a challenging task. During development, many performance related things you may encounter while working on DB2 applications. Else, it is expensive for the projects, since it takes more CPU time. I am just quoting Craig Mullen’s… Read More ⇢
Srinimf 