what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
- 6 Answers
- 13144 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 |
What is the benefit of partitioning a session?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
Explain incremental aggregation in informatica
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
Explain Dataware house architecture .how data flow from intial to end?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Make a note of the quantity vaults made in informatica?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
Teradata 
