create table newtable as select distinct * from original tablename; by d

How to delete duplicate record in Informatica?

Question Posted / sarvesh

Answer Posted / sarvesh

create table newtable as select distinct * from original
tablename;
by doing this we can elimate the duplicate rows

Is This Answer Correct ?

6 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Write the unconnected lookup syntax and how to return more than one column.

1046

How you know when to use a static cache and dynamic cache in lookup transformation?

1790

Is there any way to read the ms excel datas directly into informatica?

977

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1093

What is informatica? Why do we need it?

1038

How can we delete duplicate rows from flat files?

1160

What is joiner change?

1077

What is a repository? And how to add it in an informatica client?

1080

Explain sessions. Explain how batches are used to combine executions?

951

Explain lookup transformation is active in informatica

1030

What is an expression transformation?

967

expain about the tune parameters?

2334

Can we change Dynamic to Static or Persistent cache? If so what happens?

2145

What is the surrogate key?

1143

Informatica settings are available in which file?

935