in my source table i want to delete first and last records and
load in between records into target? how can it possible?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is predefined event?
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
What does command task mean?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
What is the function of union transformation?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
How to load query faster,so that It will take less time to load?