How to load duplicate records in to a target table which
has a primary key?
- 2 Answers
- 6865 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradeeshkumar
Loading duplicate records into a target table which has a
primary key is just a height of Brain failure.
The concept of primary key itself fails. If you still want
to insert it, better don't have any primary key
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / 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 |
What is the main difference between a Joiner Transformation and Union Transformation?
How can we update a record in the target table without using update strategy?
what is upstream and downstream transformation?
what is mean by grouping of condition column in lookup transformation?
if i am having 10 records in source, i want 20 records in target...how will you do it
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
The question was on time stamp. what is the difference between HH and HH24 when to use when.
how can u approach u r client
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
difference between shortcut and reusable transformation?
What is the difference between procedure and stored procedur?
Teradata 
