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
In informatics server which files are created during the session rums?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
update strategy transformation in informatica
What is sq transformation?
What are the main issues while working with flat files as source and as targets ?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is informatica worklet?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is target load order?
What is the need of etl tools?
What are the various types of transformation?
How can you increase the performance in joiner transformation?
What is informatica powercenter repository?
What are the data movement modes in informatica?
