Answer Posted / sunil kumar singh
Surrogate Key is artificial that is created for
datawarehousing for generating the unique number for each
record. Surrogate key works on the behalf of primary key.
And main purpose of surrogate key is to maintain the
historical record.
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
What is the difference between a connected look up and unconnected lookup?
Can we override a native sql query within informatica?
What is the difference between stop and abort in informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
tell me about your project functionality
What is decode in static cache?
How many dimensions are there in informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What do you understand by term role-playing dimension?
What do you mean by enterprise data warehousing?
When do you use sql override in a lookup transformation?
Define joiner transformation?
Do you find any difficulty while working with flat files as source and target?
What do you mean incremental aggregation?
What are roles and groups and benefits of using them?
