Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vijaya
surrogate is acts as a primary key. some times we want to
maintain historical information of particular product or
anything. for eg, a product costs 20rs in the month of may
and next month it costs 25rs. in this case if we want to
maintain both records with same product_id then it cant be
possible if product_id is primary key. In this case we use
concept of surrogate key. like
skey prod_id price month
1 101 20 may
2 101 25 june
in informatica this concept is used in update strategy.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is meant by lookup transformation?
What do you mean by channel change?
Explain what transformation and how many are there in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain the different kinds of facts.
Explain the mapping variable usage example in informatica
How can we remove the duplicates from flat file source?
What are active transformations.
What is expression transformation?
How can we update a record in the target table without using update strategy?
How to convert multiple rows to single row (multiple columns) in informatica
How many ways are there to do 'remove duplicate records in informatica'?
What happens when a session fails and you click on recover?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the differences between oltp and olap?
