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

@sikhivahans 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? If not what is the better way to save into another table. Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 anilkumark over 10 years ago

@sikhivahans 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? If not what is the better way to save into another table. Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data