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 the need for an etl tool?
Difference between Target-based loading and constraint-based loading?
where to store informatica rejected data?
Explain about cumulative Sum or moving sum?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How many ways are there to do 'remove duplicate records in informatica'?
What is an active transformation?
What is InformaticaPowerCenter?
Differentiate between router and filter transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Write the prerequisite tasks to achieve the session partition?
Explain the pipeline partition with real time example?
what is the hint? how to use it to reduce the query processing in program?
Describe expression transformation?
Target increases every day even though no new record was inserted