Get Off-Campus Placement Jobs Info !!!
Programs asked in Mettl Coding Round
Click To Practce List of Programs asked in Nagarro !!!

Technical Interview Questions and Answers :: Informatica

    61 / 94

    What is a persistent cache?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    62 / 94

    What is a shared cache?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    63 / 94

    What is unnamed cache and named cache?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    64 / 94

    How do you improve the performance of lookup transformation?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    65 / 94

    How do you remove Duplicate records in Informatica? And how many ways are there to do it?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    66 / 94

    Differentiate between Source Qualifier and Filter Transformation?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    67 / 94

    What are the differences between Source Qualifier and Joiner Transformation?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    68 / 94

    Differentiate between joiner and LookupTransformation.
    Answer:


    Join Transformation

    Lookup Transformation

    • It uses only = operator to match column data.
    • It has four type of joiner :
    • Normal join
    • master outer join
    • detail outer join
    • Full outer join
    • It uses =,>=,<=, != operator.
    • It work like Left outer join only.

    Joiner is active and connected transformation

    Lookup is active/passive and connected or unconnected transformation.

    Joiner transformation is used to usually to join data coming from two separate tables or source qualifiers.

    Look up transformation can be used on a single table or a query to search for records that match incoming Records


    Please Login First :

    69 / 94

    What is meant by Lookup Transformation? Explain the types of Lookup transformation.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    70 / 94

    How can you increase the performance in joiner transformation?
    Answer:

    No Discussion on this question yet!

    Please Login First :