Technical Interview Questions and Answers :: Informatica

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 .

Session properties - enable treat all rows as insert.

Target properties - enable update else insert.

No Discussion on this question yet!

No Discussion on this question yet!

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

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. 

 

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.

No Discussion on this question yet!

No Discussion on this question yet!

No Discussion on this question yet!