Question regarding a double merge operation:
Given the source data below, I am attempting to convert the date fields to
point to an identity column.
Source Data
[Name] - string
[FromDate] - DateTime
[ThroughDate] - DateTime
Destination Data
[Name] - string
[FromDateId] - Identity
[ThroughDateId] - Identity
Join Data
[Id] - Identity
[Date] - DateTime
If I only wanted to merge one column, it seems straight forward enough to
utilize the follow :
new AddWeekIdToRegionThroughDate()
// JoinOperation
.Left(new ReadSource())
// ConventionInputCommandOperation [SourceData]
.Right(new ReadWeek())
// ConventionInputCommandOperation [JoinData]
The next process will contain the merged data correctly.
However, when I want get the Id for both columns, the only structure I can
come up with is something like this:
Register(
new AddWeekIdToRegionFromDate()
.Left(
new AddWeekIdToRegionThroughDate()
.Left(new ReadSource())
.Right(new ReadWeek())
)
.Right(new ReadWeek())
);
This seems odd to me, and I was wondering if I was approaching this problem
incorrectly. ReadWeek() being called twice in the same pipeline seems
horribly inefficient. Could someone take a look at this and let me know
what is the best approach. I am having problems finding sufficient
documentation on the various operations inside of Rhino ETL, and the
included Test Samples from the source never deal with this type of
scenario. I almost feel like I should be pulling the Week data out into a
static list and then using abstract operations to manually add the field.
--
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/rhino-tools-dev.
For more options, visit https://groups.google.com/groups/opt_out.
