Answer Posted / pradeep
surrogate key is an autogenerated sequence in data warehouse
acts as primary key as the data in warehouse is highly
denormalised form.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
What is depict expression change?
What are the different versions of informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is informatica metadata and where is it stored?
What is the command used to run a batch?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is an active transformation?
What is xml source qualifier transformation in informatica?
What are multi-group transformations?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the conditions needed to improve the performance of informatica aggregator transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to do unit testing in informatica?