Answer: CDC stands for Change data capture. it means some changes in the source side.

Please Login First :

Asked In

Answer: Session properties - enable treat all rows as insert.

Target properties - enable update else insert.

Please Login First :

Asked In

Answer: No Discussion on this question yet!

Please Login First :

Asked In

Answer: No Discussion on this question yet!

Please Login First :

Asked In

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

Please Login First :

Asked In

6 / 94 View Answer | Post Your Answer | To Reading List | Asked In 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 :

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 :

Asked In

Answer: No Discussion on this question yet!

Please Login First :

Asked In

9 / 94 View Answer | Post Your Answer | To Reading List | Asked In 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 :

Asked In

Answer: No Discussion on this question yet!

Please Login First :