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 is a grid in Informatica?
What is the sql query overwrite in source qualifier in informatica
How to generate sequence numbers without using the sequence generator transformation?
What are the types of data warehouses?
Explain the difference between a data warehouse and a data mart?
What is olap (on-line analytical processing?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
explan ur project architecture?
Why filter transformation is an active one?
Separate from a database, an information bazaar, and an information stockroom?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain the code page compatibility?
What is lookup transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
State the differences between sql override and lookup override?