Ins Upd Del in one Stage
Moderators: chulett, rschirm, roy
Ins Upd Del in one Stage
Hello Every one,
I need a logic .....
I have a input file...........It consists of Inserts, Update's and Delete.
What I mean is ,suppose if I have 100 records in file........It should be load in to the table sequentially (Either Inserts, Update's or Delete have to commit one after and another)
Can any one suggest me Idea ?
I need a logic .....
I have a input file...........It consists of Inserts, Update's and Delete.
What I mean is ,suppose if I have 100 records in file........It should be load in to the table sequentially (Either Inserts, Update's or Delete have to commit one after and another)
Can any one suggest me Idea ?
Re: Ins Upd Del in one Stage
What do you mean Delete?
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You could use a design something like this. Use constraint expressions within the Transformer stage to direct records to the output links depending on whether they're insert, update or delete records.
Code: Select all
+---------+ +-------------+ +-----------+
| | | | -INS->| |
| | | | | |
| SeqFile | ----->| Transformer | -UPD->| Connector |
| | | | | |
| | | | -DEL->| |
+---------+ +-------------+ +-----------+
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact: