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
- 15010 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
How many number of sessions can one group in batches?
What is a filter transformation and why it is an active one?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
without table how to come first record only in oracle?
What is the need of an ETL tool?
Explain the scenario which compels informatica server to reject files?
What is status code in informatica?
What is the use of source qualifier?
How would you copy the content of one repository to another repository?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Why do we need informatica?
Which files are created during the session rums by informatics server?
What is decode in informatica?
What are some examples of informatica etl programs?
What is a transaction control transformation?
