why do we go for update strategy tr in SCD rather using the
session properties?
Answer Posted / srinu
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 |
Post New Answer View All Answers
What are the tasks that can be performed using sq?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the way to execute pl/sql script using informatica mapping?
what is degenerated dimension?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
what is diff b/t sorter t/r and agg have the option sorter property...
Mention few power centre client applications with their basic purpose?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is native users?
How to update or delete the rows in a target, which do not have key fields?
if we have a delimiters at unwanted places in a flat file how can we over come those.
what is the size of your data warehousing?
How to handle decimal places while importing a flatfile into informatica?
What is exclusive and normal mode for repository services?
Explain incremental aggregation in informatica