[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.

Technical Interview Questions and Answers :: Informatica

    61 / 94

    What is a persistent cache?
    Answer:

    The persistent cache in lookup transformation behaves as the cache is utilized again in the same workflow(mapping) execution on again and again.

    The Integration Service saves or deletes lookup cache files after a successful session run based on whether the Lookup cache is checked as persistent or not.


    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:

    If the lookup table is on the same database as the source table in your mapping and caching is not feasible, join the tables in the source database rather than using a Lookup transformation.
    If you use a Lookup transformation, perform the following tasks to increase performance:
    • Use the optimal database driver.
    • Cache lookup tables.
    • Optimize the lookup condition.
    • Filter lookup rows.
    • Index the lookup table.
    • Optimize multiple lookups.
    • Create a pipeline Lookup transformation and configure partitions in the pipeline that builds the lookup source.

    Please Login First :

    65 / 94

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

    IN INFORMATICA TO REMOVE DUPLICATE RECORDS BY USING

    FIRST WAY IS

    USING SOURCE QUALIFIER TRANSFORMATION CLICK ON PROPERTIES AND SELECT DISTINCT PROPERTY THEN YOU WILL REMOVE DUPLICATE RECORDS.

    BY USING SOURCE QUALIFIER YOU CAN OVERRIDE THE SQL QUERY YOU CAN REMOVE DUPLICATE RECORDS BUT IT IS WORKING ONLY FOR DATA BASE SOURCE NOT WORKING FOR FLAT FILES.

    SECOND WAY:

    IN SORTER TRANSFORMATION ALSO YOU CAN CLICK ON PROPERTIES TAB SELECT DISTINCT PROPERTY THIS SCENARIO ALSO WORKING TO REMOVE DUPLICATE RECORDS.

    THIRD WAY:

    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 :