I want to execute a query without using Query Database node. I think Query Rule

anilkumark over 10 years ago

I want to execute a query without using Query Database node. I think Query Rule is the best way execute a query for faster performance. But how to use Query Rule for multiple entities? Which is best way to execute below query?

"select T1.* from TABLE_ONE T1 , TABLE_TWO T2
where T1.CUST_ACCT_ID = T2.PRNT_ACCT_ID
and T2.ORDR_ID = pv!order_id; "

Thanks.

Discussion posts and replies are publicly visible

Parents

0 anilkumark over 10 years ago

Thanks Sonalk.
Cant we do this without creating Views. And after fetching the data, I have to insert into one another table.

Result of that query having about 40 columns. If I use Query Rule, then I have to run that Query Rule for each and every column (40 Times) in the Script Task and insert into table (CDT). Is it good?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 anilkumark over 10 years ago

Thanks Sonalk.
Cant we do this without creating Views. And after fetching the data, I have to insert into one another table.

Result of that query having about 40 columns. If I use Query Rule, then I have to run that Query Rule for each and every column (40 Times) in the Script Task and insert into table (CDT). Is it good?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data