Hi Experts,
Requirement:
i want to update a record in the table based on the record from the source.
my table basically has 3 columns
identity,datestart,dateend,flag
1 2010-01-31 9999-12-31 M
if iam getting a record frm file say
identity datestart flag
1 2010-02-28 T
Then the record in the table should be
Identifier,datestart,datend,flag
1 2010-01-31 2010-02-28 M
1 2010-02-28 9999-12-31 T
can i impement this with out using SCD?
Can This Be Possible With Out SCD?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Set the Lookup Failed rule to Continue.
In the Transformer stage detect success or failure of the lookup with an IsNull() function.
If the lookup fails, your new record goes to an Insert link.
If the lookup succeeds, your new record goes to an Insert link and the columns returned from the Lookup go to an Update link, with appropriate column derivation expressions.
In the Transformer stage detect success or failure of the lookup with an IsNull() function.
If the lookup fails, your new record goes to an Insert link.
If the lookup succeeds, your new record goes to an Insert link and the columns returned from the Lookup go to an Update link, with appropriate column derivation expressions.
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.