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
- 14310 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 |
Implementation methodology
How do you load alternate records into different tables through mapping flow?
explan ur project architecture?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
what is INFORMATICA TESTING process
what is incremental data aggregation?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
what is hash table in informatica?
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
I have 1200 records how can u send it in aggregator with good performance issues?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Teradata 
