gazulas

 Profile Answers by gazulas Questions by gazulas

• Jan 29th, 2006

 

Use a sorter transformation , in that u will have a "distinct" option make use of it .

prasadns26

 Profile Answers by prasadns26 

• Jul 18th, 2006

 

hi,

You can use a dynamic lookup or an aggregator or a sorter for doing this.

mahesh4346

 Profile Answers by mahesh4346 

• Feb 5th, 2007

 

Instead we can use 'select distinct' query in Source qualifier of the source Flat file. Correct me if I am wrong.

Prasad

• May 10th, 2007

 

You cannot write SQL override for flat file

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 13th, 2011

 

By using the sorter transformation, one can delete the duplicate values in a flat file

santanu

• May 11th, 2012

 

Use the file as source, then a sorter, and then a expression to store the previous value,filter those which matches the previous record and the load them into the same flat file as target

jayapraveen

 Profile Answers by jayapraveen 

• Jun 21st, 2012

 

SRC-->SQ-->LKP-->EXP-->UPD-->T1

LOGIC IS
LKP: EMPNO=IN_EMPNO
EXP:IIF (LKP_EMPNO=EMPNO, D,I)
ROUTER (GROUPS: DELETE----D>
INSERT---->I)
UPD_DELETE (DD_DELETE)(Connect to delete group and pass only the primary key column)
UPD_INSERT (DD_INSERT)
NOTE: take two instances of same target..
So you have to run the mapping two times.. For this
(OR)
Otherwise you can use dynamic lookup in this way
SRC-->SQ-->DY_LKP-->EXP-->UPD_T1
LOGIC:
DYNAMIC LOOKUP: Check the lookup property as dynamic
EXP:IIF (NEW_LOOKUP_ROW =0,R, I)
FILTER: NEW_LOOKUP_ROW! =0
TARGET: T1

Madhuri

• Jun 22nd, 2012

 

Use sorter transformation after SQ and check the distinct check box of sorter.finally connect to the tgt.

Chinna

• May 20th, 2013

 

Using Sorter Transformation it will delete duplicate records and using Expression Transformation...

Code