in my source table i want to delete first and last records and load in between

in my source table i want to delete first and last records and
load in between records into target? how can it possible?

Question Posted / ameen

3 Answers
8361 Views
HCL, Thomson Reuters, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

in my source table i want to delete first and last records and load in between records into target..

Answer / venkatesh

the flow will be like this
sequence generetor
|
source--->sq--->aggrigator---->filter--->target

generate sequence number using the sequence generator
connect it to the aggrigator and the flow from sq.group by
sequence num and create two o/p ports
1)min(seqnumber)
2)max(seqnumber)
in filter write the condition as
seqnumber<>min AND max

connect the required ports to the target

u will get the required o/p

Is This Answer Correct ?

17 Yes

7 No

in my source table i want to delete first and last records and load in between records into target..

Answer / mithilesh kumar rai

AGGREGATER

SQ -> JOINER > EXP >UPDST > TGT

SEQ GEN EXPRESSION

AGGREGATE: DON'T SELECT ANY GROUP BY PORT IT WILL PASS LAST.

EXP:TAKE SEQ BEFORE EXPRESSION

JOINER : JOIN AGGREGATOR AND EXPRESSION BASED ON CONDITION
DUMMY(VALUE=1)=DUMMY(VALUE=1)

EXP: OUTPUT_PORT: IIF(NEXTVAL=1 AND EMPID(EXP)=EMPID(AGGT),1,0)

UPDATE_STRATEGY: IIF(OUTPUT_PORT=1,DD_REJECT,DD_INSERT)

let me know if u r facing any problem(8147922210)

Is This Answer Correct ?

2 Yes

2 No

in my source table i want to delete first and last records and load in between records into target..

Answer / davankumar

In the aggregator t/r we have aggregate functions first and
last.with these we have to calculate.

Is This Answer Correct ?

3 Yes

11 No

Post New Answer