Interested to Buy Any Domain ? << Click Here >> for more details...
why do we go for update strategy tr in SCD rather using the
session properties?
- 3 Answers
- 16995 Views
- IBM, I also Faced
- E-Mail Answers
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 are the types of presistent cache in look up tr.
How many ways are there to create ports?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is pmcmd command?
What are Dimensional table?
Plz can any one say me how to get the informatica certification materials and dumps
What is the Process to creating lookup transformation in informatica
what is informatica metadata?
In development project what is the process to follow for an etl developer from day1
What are the tasks that can be performed using sq?
can u any challenge your project?
Can we create a Integration service without a Repository service and vice versa?
Explain the types of lookup transformation?
In how many ways we can create ports?
