Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the reusable transformations?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is a transaction control transformation?
Define enterprise data warehousing?
What are the guidelines to be followed while using union transformation?
What is union transformation in informatica?
What are junk dimensions?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How do you promote a non-reusable transformation to reusable transformation?
What is an Integration service in Informatica?
What is the need for an etl tool?
What is persistent lookup cache?
draw informatica architecture 8.6 ?
How to handle decimal places while importing a flatfile into informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
