How to load duplicate records in to a target table which
has a primary key?
- 2 Answers
- 7336 Views
- I also Faced
- E-Mail Answers
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 are the guidelines to be followed while using union transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Differences between connected and unconnected lookup?
What is meant by target load plan?
What is dimensional table?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain the mapping variable usage example in informatica
What is an active transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Briefly define a session task?
How can informatica be used for an organization?
How can we remove the duplicates from flat file source?
Define mapplet?
Quickly characterize reusable change?
what are the deliverables?in your project?
