Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shiva
surrogate key is a artificial key or system generated
key.when ever a primary key violation occurs,by using
sequence generator t/m we generate surrogate keys
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse.
What is informatica powercenter repository?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the main issues while working with flat files as source and as targets ?
Enlist the advantages of informatica.
wat are deployement groups in informatica, how it will be used for developers
Can you generate sequence numbers without using the sequence generator transformation?
How might one distinguish in the case of mapping is right or not without associating session?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is domain and gateway node?
How can you increase the performance in joiner transformation?
How union transformation is used?
