Interested to Buy Any Domain ? << Click Here >> for more details...
How to load duplicate records in to a target table which
has a primary key?
- 2 Answers
- 7854 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 |
r u done any partitions in ur project?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
what is update strategy transformation ?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
Have you worked with/created Parameter file
Define maping and sessions?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
What are the basic needs to join two sources in a source qualifier?
What is xml source qualifier transformation in informatica?
Teradata 
