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
- 9972 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
Write the different tools in the workflow manager?
can you please explain me pre session and post session options?
Which development components of informatica have the highest usage?
What is sorter transformation?
What is the surrogate key?
What is DR strategy for Informatica project?
what is Active lock explain
What does “tail –f” command do and what is its use as an Informatica admin.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
list out all the transformations which use cache?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is decode in informatica?
What does role playing dimension mean?
What is different between the data warehouse and data mart?
What is an unconnected transformation?
