If you want to create indexes after the load process which transformation you choose?a) Filter Tranformationb) Aggregator Tranformationc) Stored procedure Tranformationd) Expression Tranformation

Questions by rrvathana

Showing Answers 1 - 5 of 5 Answers

Prasad

  • Jul 14th, 2006
 

Hi,

Its usually not done in the mapping(transformation) level. Its done in session level. Create a command task which will execute a shell script (if Unix) or any other scripts which contains the create index command. Use this command task in the workflow after the session or else, You can create it with a post session command.

  Was this answer useful?  Yes

SAMREEN

  • May 17th, 2013
 

Stored Procedure

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions