Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • DB2 11 for ZO/S new features

    Summarised DB2v11 developer related enhancements. Read more.

  • DB2- V10.5 SQL Enhancements

    Starting with DB2® Version 10.5, you can use the EXCLUDE NULL KEYS clause on the CREATE INDEX statement to reduce the size of sparse indexes. An index that you create with the EXCLUDE NULL KEYS clause does not insert a key into the index object when all the columns in the key are null. Excluding…

  • Top Differences Between 8X and 9X Informatica tool

    Informatica version 8x and version 9x has many differences. Read for full list.

  • Oracle-8i -9i – 10g- 11g- 12c Differences

    Each Oracle release has many differences. All the changes you can read here. These are Developer related. We can refer at one place. There are architectural differences. Related articles Another 5 neat 12c features for Oracle developers (iadvise.eu)

  • 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 statistics gathering and advanced optimization…

  • 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 IBM and plug-compatible mainframes. Over 95…

  • 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 Applications: Designer – a developer tool…

  • 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.

  • 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.

  • Life Cycle of Data Processing: Handy Flowchart

    The complete life cycle of data science for all developers.

  • 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.

  • 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 a nested procedure call. DB2…