what is the purpose of surrogate key and diff between primary
key&surrogate key
- 1 Answers
- 5688 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 happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
What could be the possible resons of locks by user?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
replace multiple spaces with single space.
What are the phases in SDLC?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
when we go for unconnected lookup transformation? and why?
What are the designer tools for creating tranformations?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
If u r using dynamic cache lookup port will be thier in thet which option u will select
Teradata 
