Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / deepthi pathuri
A surrogate key in a data warehouse is more than just a
substitute for a natural key.
(OR)
A surrogate key is frequently a sequential number (e.g. a
Sybase "identity column") but doesn't have to be. Having
the key independent of all other columns insulates the
database relationships from changes in data values or
database design and guarantees uniqueness.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is rank transformation?
which one is better performance wise joiner or look up
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?
How to configure mapping in informatica?
What you know about transaction control transformation?
wf dont have integration severances how you can run?
Is it possible to use a client with different version than that of its Informatica server?
What is the session task and command task?
Explain load alternative records / rows into multiple targets - informatica
Sequence generator, when you move from develoment to production how will you reset
Is it possible to create multiple domains on a single Informatica server?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to extract the informatica rejected data?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
