Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mahesh manam
The main purpose of SURROGATE KEY is:
--> If you want to store the multiple records
for example:
In one general store customer id is primary key ,
If the customer change his address or phone number .
But now our requeriment is like to store all the data along
with old
-->If you are using duplicate records with out using
SURROGATE KEY like as follows:
ID NAME LOC
1 Mahesh Chennai
1 Mahesh Hyderabad
In above case if you are work with any dimmension model it
is not support to use this table. So, we need to maintain
Primary Key in each table.
-->Surrogate key is a key in that table use as a primary
key in the table to do joininng to another
-->Surrogate is very usefull and Quickly
If you are using any huge amount of data and you need to
retrive the queries which is usefull to your bussiness
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an expression transformation?
What are the prerequisite tasks to achieve the session partition?
What is the meaning of decode in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Have you worked with/created Parameter file
Explain lookup transformation is active in informatica
What is the advantage of informatica?
What is the benefit of session partitioning?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is meant by a domain?
How union transformation is used?
What is depict expression change?
What is the difference between a repository server and a powerhouse?
