How to delete first 3 rows & last 3 rows in target table in
informatica
Answer Posted / santosh kumar sarangi
create a sequence t/r and link the next value with sq t/r to
expression t/r and. Create two link.
First Link:
Connect ex t/r to update strategy t/r and keep condition as
IIF(NEXTVAL<4,DD_DELETE,DD_REJECT) and connect to target
except the nextval column.
Second Link:
Connect to sorter t/r and sort with descending order of
nextval and rename as in_nextval. create new sequence
generator and link to the same ex t/r. Link the ports to
again one more update strategy t/r and keep the same condition
as IIF(NEXTVAL<4,DD_DELETE,DD_REJECT) and link to the one
more instance of target table.
Let me know if any things wrong.
Thanks & regards,
Santosh Kumar Sarangi
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain lookup transformation in informatica
lookup transformation with screenshots
How do you use reject loader.
What does cheating measurement mean?
What are active and passive transformations?
How can repository reports be accessed without sql or other transformations?
What is sequence generator transformation in informatica?
How to join three sources using joiner? Explain though mapping flow.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is event and what are the tasks related to it?
What is repository manager?
Separate from an archive server and a powerhouse?
What is confirmed fact in dataware housing?
Differentiate between source qualifier and filter transformation?