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
- 14272 Views
- I also Faced
- E-Mail Answers
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
Define sessions in informatica etl?
How many numbers of sessions can one group in batches?
Can u generate reports in Informatica?
What differs when we choose the sorted input for aggregator transformation?
where to store informatica rejected data?
What is data transformation manager process?
What are the different versions of informatica?
What are multi-group transformations?
Please let me know how to make Data masking in informatica..
Write the prerequisite tasks to achieve the session partition?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What do you understand by SOA of Informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is workflow monitor?
What are the various types of transformation?
