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
- 10031 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
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to elaborate powercenter integration service?
Where do we use mapping variables in informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is the difference between informatics 7x and 8x and what is latest version?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Difference between Data and Index Caches?
Which transformation is needed while using the Cobol sources as source definitions?
draw informatica architecture 8.6 ?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How do you load only null records into target?
Explain in detail about scd type 1 through mapping.
Explain why we use partitioning the session in informatica?
Mention a few design and development best practices for informatica?
What is a sequence generator transformation?
