Interested to Buy Any Domain ? << Click Here >> for more details...
what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
- 6 Answers
- 14495 Views
- I also Faced
- E-Mail Answers
Answer Posted / murali
the surrogate key is the primary key used to avoid the
problem of critical column. let me clarify u with example...
table A:
Cust_no(PK) Cust_name Loc
100 X Mumbai
this is what ur OLAP DHW is having abt Customer X
But, he has changed his address from X to Y. U have to
update this in ur OLAP DWH. then, i u try to insert this
into ur Table A,
Error: Prinary key Constraint violated (Coz,PK is same for
the both the records)... then, LOC is the Critical Column.
to avoid this, we need to generate a primary key either by
user defined or system generated.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
what are factless facts? And in which scenario will you use such kinds of fact tables.
In development project what is the process to follow for an etl developer from day1
What is Session and Batches?
What is a repository? And how to add it in an informatica client?
Why union transformation is an active transformation?
What is a repository manager?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How you prepared reports for OLAP?
How can we improve session performance in aggregator transformation?
What is different between the data warehouse and data mart?
Can we create multiple integration service on single repository?
How union transformation is used?
What is a joiner transformation?
What is the need of an ETL tool?
What are Dimensional table?
