what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
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
Whats the difference between informatica powercenter server, repositoryserver and repository?
How do we call shell scripts from informatica?
What is a snowflake schema?
What if the source is a flat-file?
How an expression transformation differs from aggregator transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is data transformation manager process?
which one is better performance wise joiner or look up
What is the use of code page?
What is blocking transformation?
What is lookup change?
what is $$$$?
Under which circumstances, informatica server creates reject files?
How do you change a non-reusable transformation to reusable transformation?