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
Enlist the tasks for which source qualifier transformation is used.
How many transformations can be used in mapplets.
How to use pmcmd utility command?
What is a joiner transformation and why it is an active one?
scenario where i can use only concurrent execution of workflow.
Explain how to import oracle sequence into informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What do mean by local and global repository?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can we update a record in the target table without using update strategy?
What is meant by pre and post session shell command?
where to store informatica rejected data? How to extract the informatica rejected data?
How to Create a folder using pmrep command?
what is SDLC way of code development?
What is workflow? What are the components of the workflow manager?
