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
- 7763 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 |
How do you handle two sessions in Informatica
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
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...
expain about the tune parameters?
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
8.what is mapplet ?give example?
without dynamic lookup how to insert new rows and update existing rows?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
Whats the difference between informatica powercenter server, repositoryserver and repository?
how many types transformations supported by sortedinput?
Design a mapping to load a target table with the following values from the above source?
Where can we find the throughput option in informatica?
Teradata 
