Technical Interview Questions and Answers :: Informatica
1 / 94
CDC stands for Change data capture. it means some changes in the source side.
Tags:No Tags on this question yet!
2 / 94
Session properties - enable treat all rows as insert.
Target properties - enable update else insert.
Tags:No Tags on this question yet!
3 / 94
No Discussion on this question yet!
Tags:No Tags on this question yet!
4 / 94
No Discussion on this question yet!
Tags:No Tags on this question yet!
5 / 94
No, Sessions cannot be executed independently, a session must be added to a workflow.
Tags:No Tags on this question yet!
6 / 94
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.
Tags:No Tags on this question yet!
7 / 94
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.
Tags:No Tags on this question yet!
8 / 94
No Discussion on this question yet!
9 / 94
No Discussion on this question yet!
Tags:No Tags on this question yet!
10 / 94
No Discussion on this question yet!
Tags:No Tags on this question yet!