Technical Interview Questions and Answers :: Informatica

Question :: 1
What is CDC and How have you applied CDC technique?
 View Answer|  Post Your Answer | To Reading List | Asked In
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.
 View Answer|  Post Your Answer | To Reading List | Asked In
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).
 View Answer|  Post Your Answer | To Reading List | Asked In
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)
 View Answer|  Post Your Answer | To Reading List | Asked In
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.
 View Answer|  Post Your Answer | To Reading List | Asked In
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)
 View Answer|  Post Your Answer | To Reading List | Asked In
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?
 View Answer|  Post Your Answer | To Reading List | Asked In
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.
 View Answer|  Post Your Answer | To Reading List | Asked In
Answer:

No Discussion on this question yet!

Please Login First :

Tags:IBM Capgemini Accenture
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.
 View Answer|  Post Your Answer | To Reading List | Asked In
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.
 View Answer|  Post Your Answer | To Reading List | Asked In
Answer:

No Discussion on this question yet!

Please Login First :

Tags:No Tags on this question yet!

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• Next

   Practice Technical MCQs