Sunday, 24 February 2013


In most of the Informatica Interview the panel will come with Scenario based questions which is bit tricky and confusing. Here I have listed few scenario based questions:

      ·        How to removeduplicate rows in Informatica


  1. Alternate Approach:

    Please use SQL overide to pull all records from lookup table which satisfies the condition
    SUBSTR (Account_number, 1, 2) =’12’
    Then filter the rows from lookup which return null for this.

  2. Hi,
    Let me see if am clear in explaning my scenario, so that i shall get some good repsonses.
    I have both the source and tgt in oracle db.
    I am concerned bout 4 columns- CTR_ID, INVS_ID, ALLOC_PCT, SCHEME_ID... CTR and INVS_ID is the unique key combination in tgt. Now i need to do INS/UPD for the belwo scenarios.

    I --> For same combination of CTR_ID and INVS_ID, if a rec exists in tgt, then check for scheme_id.. if the srce and target scheme_id are different jus update the scheme_id alone in tgt.. this shall be done as TYPE I ins/update

    II --> For same combination of CTR_ID and INVS_ID, if a rec exists in tgt, then check for ALLOC_PCT.. if the srce and target ALLOC_PCT are different, then expire the current record in trgt and insert the new rec with src alloc_pct. this shall be handled in SCD2 if i m not wrong.

    III --> here comes the bottleneck!!!.. For same CTR_ID, I may have different INVS_ID in tgt.. I need to for this and apply the above scenarios .. Kindly suggest how to proceed...

  3. Informatica is a Software development company, which offers data integration products. If offers products for ETL, data masking, data Quality, data replica, data virtualization, master data management, etc.

    Informatica Powercenter ETL/Data Integration tool is a most widely used tool and in the common term when we say Informatica, it refers to the Informatica PowerCenter tool for ETL.

    Informatica Powercenter is used for Data integration. It offers the capability to connect & fetch data from different heterogeneous source and processing of data.
    informatica interview questions

  4. It’s interesting to read content like this.
    I appreciate your blog Informatica Online Course

  5. Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.
    Splunk Training Self Placed Videos

    Sap BW on Hana Training Self Placed Videos

    Sap QM Training Self Placed Videos

    Oracle Rac Training Self Placed Videos


Related Posts Plugin for WordPress, Blogger...