Interested to Buy Any Domain ? << Click Here >> for more details...
in my source table i want to delete first and last records and
load in between records into target? how can it possible?
- 3 Answers
- 9871 Views
- HCL, Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
In informatica workflow manager, how many repositories can be created?
What is the sequence generator transformation in informatica?
Differentiate between Load Manager and DTM?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the function of aggregator transformation?
Explain how to import oracle sequence into informatica?
update strategy transformation in informatica
In warehouses how many schemas are there?
Name the different lookup cache(s)?
differences between service based and product based?
What are the features of complex mapping?
Can you generate sequence numbers without using the sequence generator transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the reusable transformation?
Please let me know how to make Data masking in informatica..
