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
- 14297 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 Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Can you copy the session to a different folder or repository?
What is rank transformation in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
how can one eliminate dupliacte data with out using distinct option?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is lookup transformation?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
Teradata 
