Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • Informatica – Session Performance

    Optimizing informatica is a challenging task. Sr Developers work on it. There are various methods we can improve performance: 1) We need to use Grid to increase session and wf performance 2) Use push down optimization. IS will run SQL query either in Source/Target 3) Run session/wf concurrently 4) Increase DTM buffer size, Optimize buffer…

  • PLSQL Complex Interview Questions (Part 2)

    PL/SQL interview questions with answers given in sequence so that you can revise the subject from your mobile phone or desktop.

  • US – IT Recruitment Jobs in India

    This is a golden opportunity for job seekers. (Both Part time/Full time) Qualification: PUC/Degree/PG Must Speak English We provide training 45 days. Then, you will be placed in the list of US Recruitment. Salary plus commission you will get Rs 20000/- to Rs 50000/– Per Month. Job seekers must have Computer and Internet facility at…

  • What Are the Key Differences Between Parameters and Variables in Informatica?

    Informatica does have various parameters and variable to carry your ETL work effectively. Here given some of the key terms that used in Informatica tool. Read more.

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