Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajat singh
Surrogate key is the primary key for the Dimensional table.
Surrogate key is a substitution for the natural primary key.
Data warehouses typically use a surrogate, (also known as
artificial or identity key), key for the dimension tables
primary keys. They can use Infa sequence generator, or
Oracle sequence, or SQL Server Identity values for the
surrogate key.
It is useful because the natural primary key (i.e. Customer
Number in Customer table) can change and this makes updates
more difficult and also used in SCDs to preserve historical
data.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What all join we can perform in LOOKUP transformation?
permutations of mapplet
Can we create a Integration service without a Repository service and vice versa?
Where can we find the throughput option in informatica?
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,
I have a flat file, want to reverse the contents of the flat file
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is complex mapping?
COM components can be used in Informatica
can u give example for factless fact table
can anyone suggest best free Talend data integration training online
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.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
what is Active lock explain
What are the different components of powercenter?
