Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete first 3 rows & last 3 rows in target table in
informatica
- 6 Answers
- 14521 Views
- TetraSoft, I also Faced
- E-Mail Answers
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
What do you mean by filter transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is a repository? And how to add it in an informatica client?
What are the tasks that can be performed using sq?
Global and Local shortcuts. Advantages.
What does reusable transformation mean?
What is status code in informatica?
COM components can be used in Informatica
What is the difference between Active and Passive transformation?
What is the use of an aggregator cache file?
How can you define user defied event?
What is an aggregator transformation?
Why do we need informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
differences between service based and product based?
