what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
COM components can be used in Informatica
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 workflow monitor?
Explain constraint based loading in informatica
what is index?how it can work in informatica
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a sorter transformation?
Clarify the aggregator change?
What do you mean by blocking transformation?
Is stop and abort are same in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain lookup transformation source types in informatica
What is rank transformation?