Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • PL/SQL – Complex Queries (Job Interviews)

    PL/SQL Complex SQL Queries 1. What are the differences between Procedure and Function? Procedures: We can do Insert, Update and delete. It may or may not return values. Functions: We can do only SELECT operation. It ALWAYS returns value. 2. How do we call function? Functions we can give as Aggregate of column. Second way we can…

  • Informatica v9.5 new features

    The latest features that have been added in Informatica version 9.5 listed here one by one in such a way that developers can grasp these details very quickly and easily.

  • Oracle 11g R2- New features (Interview Questions)

    1) LISTAGG  function WITHIN GROUP- allows you to make, comma separated description 2) Introduced NOCOPY in BLOB/CLOB data types, so that performance can be improved 3) INVISIBLE Index, if we specify it, this is not visible to optimizer 4) SQL ACCESS ADVISOR to give suggestions on Indexes for materialized views, portioned tables 5) Extended composite partitioning ex: LIST – HASH…

  • Oracle 11g R2- LISTAGG Function

    The below is one of the best example for LISTAGG  DEPTNO ENAME ———- ———-         20   SRINI         30   RAJU         30   WARD                Desired Output:     DEPTNO EMPLOYEES ———- ————————————————–         20 SRINI         30 RAJU,WARD SQL Query: SELECT deptno, LISTAGG(ename, ‘,’) WITHIN GROUP (ORDER BY ename) AS employees FROM   emp GROUP BY deptno;     DEPTNO EMPLOYEES ———-…

  • Here’re Top Linux [UNIX] File Commands (Part 2)

    Shell scripting in UNIX is very common. To automate the things you always need to write correct script. These useful tips help you get clear idea in writing scripts. Read more.

  • UNIX shell Scripting Useful Commands – Part 1

    The top ten keywords mostly used in writing Shell scripts in UNIX or Linux.

  • Informatica Lookup Cache Why you need it

    Caches in Lookup transformation and different types and real use.

  • 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. Still I got the above…

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