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
- 9813 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
What is a standalone command task?
Why is sorter an active transformation?
How to improve the performance of a session using sorter transformation?
What is joiner transformation in informatica?
Explain how many types of dimensions are available in informatica?
Describe an informatica powercenter?
What are the different ways to implement parallel processing in informatica?
Informatica settings are available in which file?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is fact table? Explain the different kinds of facts.
Explain pmcmd command usage in informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
Is it possible to create multiple domains on a single Informatica server?
Explain why we use partitioning the session in informatica?
what is index?how it can work in informatica
