-
Informatica- Fatal Error Oradriver.cpp at line 416- Resolution
I was working on SCD type2. I got the above error. I used the lookup transformation. I set database connections properly in both Lookup properties, Session properties, Session mapping. Error: FATAL ERROR: Unexpected Condition in file[\ZeusbuilderProduction\view\powrmart\common\odl\ora cle8\oradriver.cpp] line [416]. Contact Informatica Technical Support forassistance. Aborting this DTM process due to an unexpectedcondition.… Read More ⇢
-
DB2 11 for ZO/S new features
Summarised DB2v11 developer related enhancements. Read more. 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… Read More ⇢
-
Top Differences Between 8X and 9X Informatica tool
Informatica version 8x and version 9x has many differences. Read for full list. Read More ⇢
-
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) Read More ⇢
-
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 ⇢
Srinimf 