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
- 6526 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
What are the new features of informatica 9.x at the developer level?
in realtime which situations u can use unconnected lookup transformation
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
In a table, 4 person having same salary. How to get Third person record only?
what is size of u r database?
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
what is worklet and what use of worklet and in which situation we can use it?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the advantage of persistent cache? When it should be used.
Teradata 
