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
- 14077 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
Did u used latest transformations of 8.6.0? for what?
What are the databases that informatica can connect to windows?
Do you find any difficulty while working with flat files as source and target?
What is a repository? And how to add it in an informatica client?
What are different types of transformations available in informatica?
Where can we find the throughput option in informatica?
How to generate sequence numbers?
What are session parameters ? How do you set them?
How to create a non-reusable instance of reusable transformations?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
how many types of dimensions are available in informatica?
What is informatica powercenter repository?
Have you worked with/created Parameter file
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain about cumulative Sum or moving sum?
