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
- 17005 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Hi,
Seession Properties like pre Souurce Rows
INSERT,UPDATE,REJECT,DELETE ,,
Using Session Properties We can do single flow only.
SCD aplicable for Insert,Update,,at a time using Update
Strategy trans only.
Using Update Trans we can creat SCD mapping easily.
Any Corrections Let me know
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 10 Yes | 4 No |
Answer / akhil4
using update stratagey tr (or)session properties both are same.update stratagey using at mapping level,session properties using at wf level. (it's wrong correct me)
| Is This Answer Correct ? | 1 Yes | 4 No |
What is the Router transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is shared Cache. when we will use shared Cache?
What is the difference between source qualifier transformations source filter to filter transformation?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
What is joiner transformation in informatica?
How to delete duplicate records in a flat file source?
Explain Dataware house architecture .how data flow from intial to end?
if soource is having 10 records how will u insert 20 records to target
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
Why do we need informatica?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
Teradata 
