don't choose the select distinct option and run the session again.u will find duplicate rows in u r target.

thanks  srinivas n shanthi  for ur answer.

 But my querie is different means suppose if u hv 10 records in source thn i want same 10 records should b loaded twise such tht i should get all records twise means 20 records n only in single target table .

use this syntex

insert into table1 select * from table1

(table1 is the name of the table)

If the record is entered in the table, and always the records have to be duplicated, then its better to have a trigger which fires for every insert on the table.

insert into table1 select * from table1  ........this may  not be useful if the table has contraints on it

how to get particular record from the table in informatica?


using a where clause


and to get the records starting with A..write an SQL query in Source Qualifier transformation as..

SELECT * FROM TABLENAME WHERE ENAME LIKE 'A%';