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
- 6575 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 |
Can we get 1st record through Informatica(without sequence number).
how can we perform incremental aggregation?explain with example?
What is the query to find nth highest salary? What is the use of cursors?
If u r using dynamic cache lookup port will be thier in thet which option u will select
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
What is native users?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
Is there any model difference between ODS and DWH
How do you load first and last records into target table?
Differentiate between router and filter transformation?
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
If we have lookup table in workflow how do you trouble shhot to increase performance?
Teradata 
