Technical Interview Questions and Answers :: Informatica

    1 / 94

    What is CDC and How have you applied CDC technique?
    Answer:

    CDC stands for Change data capture. it means some changes in the source side.

    Please Login First :

    Tags:No Tags on this question yet!

    2 / 94

    Without using update strategy trns how do we do insert update.
    Answer:

    Session properties - enable treat all rows as insert.


    Target properties - enable update else insert.

    Please Login First :

    Tags:No Tags on this question yet!

    3 / 94

    Debug option in informatica(to find out which transaction has failed).
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    4 / 94

    Session statistics(without checking the logs to find out which session has failed and where)
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    5 / 94

    Can session be run without workflow.
    Answer:

    No, Sessions cannot be executed independently, a session must be added to a workflow.

    Please Login First :

    Tags:No Tags on this question yet!

    6 / 94

    Why scd2? can we do insert update in scd1 and how?(what if we have a new record and our mapping is scd1)
    Answer:

    SCD2 allow keep the current and historical data in table. 



    SCD1 allows keep only current data. Not the historical data. 



    can we do insert update in scd1 and how?



    Ans: Yes SC|D1 allows to insert update in data. 



     

    Please Login First :

    Tags:No Tags on this question yet!

    7 / 94

    Oracle question: Difference in view and materialized views? Have you used views or synonyms?
    Answer:

    3 types of views
    Simple,complex, m view
    M views are used to increase the performance, it is like snapshot of the table. Stores result of the query

    Views are virtual table, logical set of one r more tables.

    Please Login First :

    Tags:No Tags on this question yet!

    8 / 94

    Difference in instance and database.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    9 / 94

    Do you know any other design than star or snowflake schema. If we do not want to use both then what to use and how.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    10 / 94

    Which all transaction have sql option.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!