what is unique constraint error ?

Answers were Sorted based on User's Feedback



what is unique constraint error ?..

Answer / sreedhar lokaray

Before answering this question I think you know what is a
unique constraint? This means no two values in the given
column are equal but null values are allowed. When you
receive same value again in a new record for that column
then it will throw unique constraint error.

Is This Answer Correct ?    1 Yes 0 No

what is unique constraint error ?..

Answer / nagendrareddy

unique is constraint which will not allow duplicate records
into batabase..

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  


Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,


What is the use of an aggregator cache file?

0 Answers  


suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,


what is the size of u r source(like file or table)?

0 Answers   HP,






Define pmcmd command?

0 Answers  


Separate from a database, an information bazaar, and an information stockroom?

0 Answers  


MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  


i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,


How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  


Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  


when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  


Categories