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
- 10174 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 happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the function of union transformation?
What are the types of schemas we have in data warehouse.
Write the program through which the records can be updated?
How can we improve session performance in aggregator transformation?
Scheduling properties,whats the default (sequential)
What are the components of workflow manager?
What are the transformations that are not supported in mapplet?
Different circumstance which drives informatica server to expel records?
wf dont have integration severances how you can run?
What is meant by query override?
Explain the shared cache and re-cache?
How to update or delete the rows in a target, which do not have key fields?
Informatica settings are available in which file?
How many numbers of sessions can one group in batches?
