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

    71 / 94

    How do you update the records with or without using Update Strategy ?
    Answer:

    With Update Strategy : It becomes easier as DD_UPDATE does the work using update strategy transformation.

    Without Update Strategy:

    Please Login First :

    72 / 94

    Why update strategy and union transformations are Active? Explain with examples.
    Answer:


    1. The Update Strategy changes the row types. It can assign the row types based on the expression created to evaluate the rows. Like IIF (ISNULL (CUST_DIM_KEY), DD_INSERT, DD_UPDATE). This expression, changes the row types to Insert for which the CUST_DIM_KEY is NULL and to Update for which the CUST_DIM_KEY is not null.

    2. The Update Strategy can reject the rows. Thereby with proper configuration, we can also filter out some rows. Hence, sometimes, the number of input rows, may not be equal to number of output rows.



    Like IIF (IISNULL (CUST_DIM_KEY), DD_INSERT,



    IIF (SRC_CUST_ID! =TGT_CUST_ID), DD_UPDATE, DD_REJECT))



    Here we are checking if CUST_DIM_KEY is not null then if SRC_CUST_ID is equal to the TGT_CUST_ID. If they are equal, then we do not take any action on those rows; they are getting rejected.



    Union Transformation



    In union transformation, though the total number of rows passing into the Union is the same as the total number of rows passing out of it, the positions of the rows are not preserved, i.e. row number 1 from input stream 1 might not be row number 1 in the output stream. Union does not even guarantee that the output is repeatable. Hence it is an Active Transformation.

    Please Login First :

    73 / 94

    How do you load only null records into target? Explain through mapping flow.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    74 / 94

    How do you load alternate records into different tables through mapping flow?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    75 / 94

    How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    76 / 94

    I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    77 / 94

    How do you load unique records into one target table and duplicate records into a different target table?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    78 / 94

    Differentiate between Router and Filter Transformation?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    79 / 94

    I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    80 / 94

    How do you load more than 1 Max Sal in each Department through Informatica or write sql query in oracle?
    Answer:

    No Discussion on this question yet!

    Please Login First :