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
- 13999 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
Is it possible to define a single node as a Gateway node as well as worker node?
Define sessions in informatica etl?
How to do the error handling of if ur source is flatfiles?
Define update strategy?
Mention few advantages of router transformation over filter transformation.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How is union transformation utilized?
Explain your project of banking domian.
What is exclusive and normal mode for repository services?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is mean by complex business rule ?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What do you understand by a term domain?
Under what condition selecting sorted input in aggregator may fail the session?
