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
- 7738 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 |
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
What is mapplet in informatica?
Write the advantages of partitioning a session?
"Change cache" in Informatica ?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
Why use the lookup transformation ?
How many types of sessions are there in informatica.please explain them?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
Suppose we do not group by on any ports of the aggregator what will be the output?
Teradata 
