Note 1

Take Note:

Take a note while surfing.





Note With Ink

Give your Note a Colorful Tag.




Easy to Access

Stay on same information and in Sync wherever you are.

Note 2

Take Note:

Organize your information,It may take Shape.





Think With Ink

Differ your Content by Color.




Easy to Access

Easy to pull up your content from anywhere anytime.

Note 3

Take Note:

Don't Let information to miss,Because it take shape





Note With Ink

Simple an Easy Way to take a note.




Easy to Access

Get the same in next visit.


Please wait...

  Take Quiz (Monsoon) Beta Version !!
  Do You have Qs. in your Mind ??? Ask it as Qs. or MCQs or create it as polling Live Now !!

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. Yes I have worked on it , when there is change in one of the prominent field for a record you must capture it according to SCD 1 or SCD 2 logic .

    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!