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..

WHat all joins are there in Source Qualifier?

1 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

What is workflow? What are the components of workflow manager?

0 Answers  

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

---

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

---

What is meant by pre and post session shell command?

0 Answers  

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

---

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

---