Srinimf

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

  • UNIX shell Scripting Useful Commands – Part 1

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

    UNIX shell Scripting Useful Commands – Part 1

  • Informatica Lookup Cache Why you need it

    Caches in Lookup transformation and different types and real use. Read More ⇢

    Informatica Lookup Cache Why you need it