what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
Answer Posted / kalpana
Some times the primary constraint may violate at that time
we go for surrogate key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Differentiate between Load Manager and DTM?
difference between repository database and repository service?
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?
Enlist the advantages of informatica.
Enlist some properties of sessions.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Partition, what happens if the specified key range is shorter and longer
What is status code in informatica?
How to configure mapping in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Mention a few design and development best practices for informatica?
Define Pmrep command?
can anyone suggest best free Talend data integration training online
What do you understand by term role-playing dimension?