I have a dataflow with a query transform which does a join of 3 tables and has an orderby clause on the result.
This transform would be giving output (to flat file)of nearly 15,000 rows .
I have 3 such dataflows which run in parallel since the source tables are differenct for each dataflow.
Please advice if it would be better to use a SQL transform to perform this operation instead of query transform.
Since I have a doubt that using query transform causes BODS memory to peak for a few seconds.
SuCheri (BOB member since 2011-11-18)
If it is a cross join then you may end up having BODS consuming lot of memory and eventually log becoming full. Else query transform should work well.
Arun
Arun.K 
(BOB member since 2011-10-18)
well …it is a cross join.
SuCheri (BOB member since 2011-11-18)
Cross join is a tricky situation which might create issues in BODS as well as the database. You may have to create a relation ship between the tables to work.
Arun
Arun.K (BOB member since 2011-10-18)
I don’t think the memory shoot is because of the join really (may be 
)
But how come cross join on for all? Are you sure on that?
How many Optimized SQL’s generated on your dataflow? 1 or 3?
ganeshxp (BOB member since 2008-07-17)