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 are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

---

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

---

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

---

What is difference macros and prompts?

2 Answers  

---

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---

What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  

---

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

---

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  

---