Answer Posted / vignesh muralidharan
Type1: No historical datas will be available, when changes
are made the old data will be deleted and the new data will
be insrted.
Type2: Flag:The old data will be denoted as false and the
new data will be denoted as true.
Version:The changes made will be numbered as 0,1,2...so on.
Date:The changes along with the date in which they are made
are clearly mentioned.
Type3:The latest change which is made is alone available.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How many transformations can be used in mapplets.
What is the use of code page?
How to generate or load values in to the target table based on a column value using informatica etl tool.
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 we can use union transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the difference between a connected look up and unconnected lookup?
Differentiate between a database and data warehouse?
without table how to come first record only in oracle?
What is the Rank index port in Rank transformation?
what is the size of your data warehousing?
How can we delete duplicate rows from flat files?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?