InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
If You Want To Create Indexes After The Load Process Which Transformation You Choose? |
|
Answer» 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. 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. |
|