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
What are the guidelines to be followed while using union transformation?
State the differences between sql override and lookup override?
What are the differences between source qualifier and joiner transformation?
Global and Local shortcuts. Advantages.
During the running session, output files are created by informatica server. Enlist few of them.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How are the sources and targets definitions imported in informatica designer?
How can we use mapping variables in informatica? Where do we use them?
How identifying bottlenecks in various components of informatica and resolving them?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the tuning techniques you applied during your last project
Explain lookup transformation in informatica
How to load last n records of file into target table - informatica
What is the sql query overwrite in source qualifier in informatica