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 do you understand by SOA of Informatica?
Describe expression transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Why do you use Mapping Parameter and mapping variable?
What is the difference between a repository server and a powerhouse?
What you know about transaction control transformation?
What is resilience time?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
what is $$$$?
What can we do to improve the performance of informatica aggregator transformation?
What do you mean by blocking transformation?
How you can differentiate between connected lookup and unconnected lookup?
Explain load alternative records / rows into multiple targets - informatica
What is the use of an aggregator cache file?
Explain what are the different versions of informatica?