what is the purpose of surrogate key and diff between primary
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||1 No|
Is there any target staging area in informatica not staging area
If I have a index defined on target table and if set it to bulk load will it work ?
what is data driven?
what is materialized view?
What is the difference between SOURCE and TARGET BASED COMMITS?
In joiner, how to load Master table in Target?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
Can we insert and update a target table without using update strategy transformation?How?
What is limitations of truncate and load option
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
What is a unit Testing?