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 is update strategy transform?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is the Process to creating lookup transformation in informatica
Explain transaction control transformation in informatica
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is data caches/ index caches?
what is informatica metadata?
What are the various types of transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What do think which one is the better joiner or look up?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
In informatica workflow manager, how many repositories can be created?
What is the maplet?