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

What are the measure objects?

1251

What are the different versions of informatica?

1331

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

1156

what is SDLC way of code development?

2089

What is rank index in rank transformation?

1126

How do you migrate data from one environment to another?

1138

Enlist the various types of transformations.

1118

How does the aggregator transformation handle null values?

1190

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2476

What is confirmed fact in dataware housing?

7097

What is powercenter on grid?

1223

What is the need of etl tools?

1175

What is mapping debugger?

1064

How to load last n records of file into target table - informatica

1131

Is it possible to define a single node as a Gateway node as well as worker node?

1175