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.

Answer / nagendrareddy

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

HOW TO YOU LOAD TIME DIMENSION

1 Answers  

---

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,

---

Implementation methodology

0 Answers  

---

How do you recover rows from a failed session

1 Answers  

---

version controlling in informatica?

3 Answers  

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

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,

---

What is the difference between informatica 7.0 and 8.0?

0 Answers  

---

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---