what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
- 6 Answers
- 12159 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / dr.jornalist
Surrogate Key:- Surrogate key is a system generated primary
key used in informatica for maintaining history of values.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / soujanya
surrogate key is the system generated key to avoid primary
key conatraint.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raghureddy
It has system generated artificial primary key values .
which allows to maintian historical data in dwh
| Is This Answer Correct ? | 0 Yes | 0 No |
Enlist the differences between database and data warehouse.
What is the Rank index port in Rank transformation?
What is the difference Between Mapping parameter and variable
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
What is IQD file?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
In a sequential batch can you run the session if previous session fails?
difference between informatica 8.1.1 and 8.6
In how many ways we can create ports?
In which scenario did you used pushdown optimization?
Is snow flake or star schema used? If star schema means why?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Teradata 
