How to load duplicate records in to a target table which
has a primary key?
Answer Posted / jay
Is that primary key column in the target is different,
than this is called surrogate key which is obtained
from Sequential generator (with or without combination of
key value from source. if combined with source primary key
column, then it is known as creating frequency for
each source primary column value)
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What the difference is between a database, a data warehouse and a data mart?
What does cheating measurement mean?
What are ETL Tools?
Which are the different editions of informatica powercenter that are available?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is a pre-defined event and user-defined event?
What is native users?
What differs when we choose the sorted input for aggregator transformation?
Explain the types of transformations?
How many transformations can be used in mapplets.
COM components can be used in Informatica
How identifying bottlenecks in various components of informatica and resolving them?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Is it possible to use a client with different version than that of its Informatica server?