Thanks,
I'll have to try a couple more things. I guess I thought because it was a
join, you had to join it to something related in both tables but it sounds
like you're saying you do not so that is something I'll have to get used to.
On Friday, June 15, 2012 3:39:16 PM UTC-5, Jason Meckley wrote:
>
> ETL is about processing Rows (in memory objects), where the rows come from
> doesn't matter. Joins occur in memory allowing you to relate disjointed
> data. So whether the table is unrelated doesn't apply in the scope of the
> ETL process. here is an example of what I mean. And this is all off the top
> of my head.
>
> Initialize()
> {
> Register(new MyLeftJoinOperation()
> .Left(new GetDataFromHere())
> .Right(new MyInnerJoinOperation()
> .Left(new
> GetDataFromThere())
> .Right(Partial
> .Add(new
> GetDataFromYetAnotherPlace())
> .Add(new
> TransformBeforeJoining())
> )));
> Register(new TransformRows());
> Register(new SendDataOut());
> }
>
> My guess is you will need to use a combination of Nested Join operations
> and the PartialProcessOperation.
>
> On Friday, June 15, 2012 1:22:37 PM UTC-4, John Strzempa wrote:
>>
>> What if it's data from an unrelated table but you still want to look at
>> some of it's data throughout the process? Can I just add to the row
>> somehow? Is there a right way to do this?
>>
>> On Friday, June 15, 2012 11:32:17 AM UTC-5, Jason Meckley wrote:
>>>
>>> using a single db input command per query and a join operation to merge
>>> them together.
>>>
>>> On Friday, June 15, 2012 9:32:25 AM UTC-4, John Strzempa wrote:
>>>>
>>>> Hello,
>>>>
>>>> How can I use multiple select statements per process. I have a get
>>>> products operation that selects all the products from source database but
>>>> I
>>>> also want to query the destination database and use the rows there
>>>> throughout the process for comparing etc... Would I just add to the
>>>> already
>>>> selected rows?
>>>>
>>>
--
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rhino-tools-dev/-/_uFJoMHIqIQJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rhino-tools-dev?hl=en.
