I will compare the performance and come back...meanwhile small change in the job design...
i have to run one more query in the job.
Existing Structure:
Code: Select all
rowgenerator --> transformer --> column export ---------------
|
ODBC --> transofrmer --> column export -----------------> funnel ----file
| |
| |
v v
aggregator --> transformer --> column export ---
I have to run one more sql query and need to concatenate both the result.
I can use UNION in a single query. But the problem is....
as we pull the historical records if i put 'union' between two query, query is taking long time. Note, the structure of the queries are same.
so I have planned to add the below setup once again in the existing setup.
ODBC --> transofrmer --> column export --> funnel
I hope It should work fine. But the problem is getting row count for the FOOTER ???
can you please help me to resolve this issue?