why do we go for update strategy tr in SCD rather using the
session properties?
Answer Posted / shweta
Actually its important to use a update strategy
transofmration in the SCD's as SCDs maintain some historical
data specially type 2 dimensions. In this case we may need
to flag rows from the same target for different database
operations. Hence we have no choice but to use update
strategy as at session level this will not be possible.
Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
What is complex mapping?
How we can create indexes after completing the load process?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is Data Caches size?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the restrictions of union transformation?
difference between repository database and repository service?
What is intricate mapping?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are the different types of repositories created using informatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is a dimensional model?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is aggregator transformation in informatica?
What could be the possible resons of locks by user?