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...

Technical Interview Questions and Answers :: Informatica

    Question :: 1
    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!

    Question :: 2
    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!

    Question :: 3
    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!

    Question :: 4
    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!

    Question :: 5
    Can session be run without workflow.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 6
    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!

    Question :: 7
    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!

    Question :: 8
    Difference in instance and database.
    Answer:

    No Discussion on this question yet!

    Please Login First :
    Question :: 9
    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!

    Question :: 10
    Which all transaction have sql option.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!