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 is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

---

What are the types of presistent cache in look up tr.

0 Answers   IBM,

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

how can u tune u r informatica mapppings

2 Answers   CTS,

---

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

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

9 Answers   Cap Gemini, Target,

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---