Srinimf

Advertisements

  • 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… Read More ⇢

    Informatica – Session Performance

  • 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. Read More ⇢

    PLSQL Complex Interview Questions (Part 2)

  • 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… Read More ⇢

  • 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. Read More ⇢

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

  • 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… Read More ⇢

    PL/SQL – Complex Queries (Job Interviews)

  • 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. Read More ⇢

    Informatica v9.5 new features

  • 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… Read More ⇢

  • 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… Read More ⇢

  • 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. Read More ⇢

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