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

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)

Answer / davankumar

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

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

Scheduling properties,whats the default (sequential)

0 Answers  

---

What is synonym?

2 Answers   Patni,

---

What is fact table? Explain the different kinds of facts.

0 Answers  

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

---

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---