-
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 ⇢
-
Pig, Hive, Jaql- Differences
Pig, Hive, and Jaql have much in common. They all translate high-level languages into MapReduce jobs. There are few key differences among those,which help you understand much better of these high level languages. Read More ⇢
-
COBOL Low Values Vs High Values
Low values and High values in COBOL explained with examples Read More ⇢
Srinimf 