Answer Posted / murali udayagiri

Assume some duplicate data is there in emp table. Try the
below to eliminate duplicate.

select * from emp
union
select * from emp;


Thanks,
Murali Udayagiri

How can we store previous session logs?

1078

---

Where can we find the throughput option in informatica?

1063

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1708

---

What are connected or unconnected transformations?

1121

---

Write the unconnected lookup syntax?

1084

---

What are the advantages of informatica?

1012

---

have u done any performance tuning? how u ll do?

2299

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1795

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1169

---

What is InformaticaPowerCenter?

1136

---

what is Active lock explain

2799

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2454

---

Why union transformation is an active transformation?

1047

---

How does a sorter cache works?

1069

---

Differentiate between source qualifier and filter transformation?

1578

---