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

What is a joiner transformation and why it is an active one?

998

---

What is the difference between stop and abort in informatica

1042

---

What will be the approach?

929

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1004

---

How many ways a relational source definition can be updated and what are they?

952

---

Can we create multiple integration service on single repository?

1132

---

What is a standalone command task?

1134

---

Reusable transformation and shortcut differences

1779

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2207

---

How to partition the Session?

1040

---

What are mapplets? How is it different from a Reusable Transformation?

1032

---

What is a code page?

1115

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1986

---

What is lookup transformation?

1002

---

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?

1107

---