How to load duplicate records in to a target table which
has a primary key?
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 |
How to delete duplicate record in Informatica?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
what is the difference between stop and abort
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
What is the use of an aggregator cache file?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
what is fact and what types of fact tables is there
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the session task and command task?
In informatics server which files are created during the session rums?