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
- 14196 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 |
how to duplicates from expression transformation without using sorter before that
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is the difference between onsite & client site?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
What are the types of maping in Getting Started Wizard?
When do you use sql override in a lookup transformation?
What is a look up function? What is default transformation for the look up function?
How to load the source table into flat file target(with columns) in informatica?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
Implementation methodology
where to store informatica rejected data?
Teradata 
