Interested to Buy Any Domain ? << Click Here >> for more details...
what is the purpose of surrogate key and diff between primary
key&surrogate key
- 1 Answers
- 6679 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / suresh
primary-key:-
It represents one or more fields or attributes that uniquely identified each record in a database table.
surrogate-key:-It is a single part,artificially established identifier an entity,surrogate key assignment is a special case of derived data-one where the primary is derived.A common way that surrogate key values is to assign integer values sequentially.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is flashback table ? Advance thanks
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is rank transformation?
Explain the difference between mapping parameter and mapping variable?
Briefly explain the aggregator transformation?
How can we create index after completion of load process?
What is meant by a domain?
Write the different tools in the workflow manager?
What is transformation?
What is decode in informatica?
What is a sorter transformation?
What are the main issues while working with flat files as source and as targets ?
What is the difference between router and filter?
Plz can any one say me how to get the informatica certification materials and dumps
