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
Difference between Target-based loading and constraint-based loading?
How to load the data from a flat file into the target where the source flat file name changes daily?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What the difference is between a database, a data warehouse and a data mart?
What is the session task and command task?
What is rank index in rank transformation?
How many numbers of sessions can one group in batches?
Define enterprise data warehousing?
How can repository reports be accessed without sql or other transformations?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the databases that informatica can connect to windows?
How to load the data from people soft hrm to people soft erm using informatica?
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.
Parameter and variable differences
Explain the code page compatibility?
