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
- 6520 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 are the types of lookup transformation?
Whats there in global repository
What is the need for an etl tool?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
State the differences between sql override and lookup override?
How can we update a record in the target table without using update strategy?
Briefly define reusable transformation?
What is a filter transformation?
What are mapplets? How is it different from a Reusable Transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a stored procedure transformation?
What is deployment group?
can we override a native sql query within informatica? Where do we do it? How do we do it?
where to store informatica rejected data?
Differentiate between sessions and batches?
