WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
Answer Posted / uzval_vee
hai
i guess this question comes under scd's itseems,
becoz in scd type1 we will overwrite the oldvalue with new
value.here we dont have any history
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
What is expression transformation?
Please let me know how to make encryption and decryption with example?
Which is the t/r that builts only single cache memory?
Define the various join types of joiner transformation?
What is the procedure for creating independent data marts from informatica 7.1?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the types of data warehouses?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Does an informatica transformation support only aggregate expressions?
Explain in detail about scd type 1 through mapping.
Informatica Checkpoints
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to extract the informatica rejected data?
What are batches?