Interested to Buy Any Domain ? << Click Here >> for more details...
What is a surrogate key?Why we use it in a mapping?Pl give
an example.
- 4 Answers
- 12220 Views
- PCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
surrogate key is a System generated Key ( Artificial
key ),Every join between dimension tables and fact tables
in a data warehouse environment should be based on
surrogate keys, not natural keys.
There are still more reasons to use surrogate keys. One of
the most important is the need to encode uncertain
knowledge. You may need to supply a customer key to
represent a transaction, but perhaps you donýt know for
certain who the customer is. This would be a common
occurrence in a retail situation where cash transactions
are anonymous, like most grocery stores.
What is the customer key for the anonymous customer?
Perhaps you have introduced a special key that stands for
this anonymous customer. This is politely referred
to as a "hack."
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How would you copy the content of one repository to another repository?
What is InformaticaPowerCenter?
What is informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
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?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Briefly describe lookup transformation?
What is a sorter transformation?
Define pmcmd command?
What are the measure objects?
Explain why we use partitioning the session in informatica?
In development project what is the process to follow for an etl developer from day1
What is informatica powercenter repository?
Plz can any one say me how to get the informatica certification materials and dumps
