Answer Posted / shiva
surrogate key is a artificial key or system generated
key.when ever a primary key violation occurs,by using
sequence generator t/m we generate surrogate keys
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
generate date / time dimension in informatica
what is the hint? how to use it to reduce the query processing in program?
if we have a delimiters at unwanted places in a flat file how can we over come those.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is the maplet?
I have a flat file, want to reverse the contents of the flat file
What is a connected transformation?
tell me about your project functionality
how to create user defined function (udf) in informatica
What are the new features of informatica 9.x at the developer level?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How can we use batches?
Explain the shared cache and re-cache?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.