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

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

What are the data movement modes in informatcia?

3 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

what is galaxy repository?

2 Answers  

---

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---

How big was your fact table

0 Answers  

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

What is a grid in Informatica?

0 Answers  

---

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---