OXIESEC PANEL
- Current Dir:
/
/
home
/
cubot
/
docroot
/
help
/
help_etl
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
08/14/2022 11:08:45 AM
rwxr-xr-x
📄
AbouttheETLTab.html
5.88 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
AccessLog.html
5.21 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
AdministratorResponsibilities.html
3.92 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
CUBOT 9.0 ETL ADMIN GUIDE.html
1.04 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
CUBOTMenu.html
6.93 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
CUBOTataGlance.html
3.63 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
CopyrightandTrademarkInformation.html
4.11 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
CubotLog.html
5.23 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
ETLLog.html
9.25 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
ElementsofCUBOTScreens.html
2.38 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
ErrorLog.html
5.67 KB
08/14/2022 11:08:47 AM
rw-r--r--
📄
GettingStarted.html
21.97 KB
08/14/2022 11:08:47 AM
rw-r--r--
📄
HowToAddaLog.html
4.98 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowToCreateaDataTemplate.html
13.29 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowToDeleteaDataTemplate.html
3.99 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
HowToEditDetailsofaProcess.html
4.68 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowToEdittheDataTemplateDetails.html
5.66 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowToViewDetailsofaProcess.html
13.5 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowToViewDetailsofaWorkflowSched.html
12.36 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowToViewandExportData.html
3.39 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoAddColumnstoaDataTemplate.html
3.31 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAddaDatabase.html
13.37 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoAddaDirectory.html
15.34 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAddaMdbFile.html
3.48 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAddaNewMaskSourceTable.html
10.84 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
HowtoAddaNewProcess.html
4.37 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoAddaNewRepository.html
5.21 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoAddaNewStore.html
8.63 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoAddaNewWorkflow.html
8.74 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
HowtoAddaSalesforceStore.html
6.19 KB
08/14/2022 11:09:06 AM
rw-r--r--
📄
HowtoAddaTask.html
5.52 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAddaXMLFile.html
3.63 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAddanETLTask.html
5.23 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
HowtoAddanExcelFile.html
3.48 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoAnalyzeaSQLQuery.html
5.27 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAnalyzeaTable.html
5.91 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoDefineaNewCommandTask.html
4.68 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoDefineaNewSQLQuery.html
4.74 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoDefineaNewTasktoaWorkflow.html
3.66 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoDeleteaLog.html
4.18 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoDeleteaProcess.html
3.98 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoDeleteaProcessSchedule.html
4.83 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoDeleteaRepository.html
4.79 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
HowtoDeleteaStore.html
4.78 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoDeleteaTask.html
4.18 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
HowtoDeleteaTask1.html
4.56 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoDeleteaWorkflow.html
4.46 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoDeleteaWorkflowSchedule.html
4.82 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoDeleteaWorkflowTask.html
4.61 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoEditDetailsofaLog.html
3.45 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoEditDetailsofaWorkflow.html
4.14 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoEditDetailsofaWorkflowSched.html
5.48 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
HowtoEditMaskDetails.html
4.67 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoEditSearchDetails.html
6.58 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoEditStoreDetails.html
3.58 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoEdittheDetailsofaProcessSch.html
5.72 KB
08/14/2022 11:09:07 AM
rw-r--r--
📄
HowtoEdittheRecordsinaMasterTabl.html
10.43 KB
08/14/2022 11:08:47 AM
rw-r--r--
📄
HowtoEdittheRepositoryDetails.html
4.42 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoGrantAccessPermissions.html
6.52 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoImportaTable.html
4.08 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoInsertNewRecordstoaMasterTa.html
6.74 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoLinkaWorkflowtoAnotherWorkf.html
5.83 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoLogontoCUBOT.html
3.41 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
HowtoManagetheTasks.html
13.84 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoMoveaTask.html
3.54 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoMoveaTaskBetweenWorkflows.html
3.7 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
HowtoReorderaTask.html
3.52 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoReorderaWorkflowTask.html
3.57 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoScheduleaProcess.html
5.87 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoScheduleaWorkflow.html
5.64 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoSelectaDestinationTableScre.html
10.68 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoSetPrimaryKeyOptiontoaField.html
7.59 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoViewDatainaTable.html
9.4 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoViewDetailsofaTask.html
10.37 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoViewDetailsofaWorkflow.html
9.71 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoViewtheCheckList.html
4.51 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoWorkwiththeExtractScreen.html
9.41 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoWorkwiththeTransformationSc.html
10.84 KB
08/14/2022 11:09:12 AM
rw-r--r--
📄
TypesofCUBOTLogs.html
5.42 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
UserInformation.html
5.71 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
WhyyoushouldSignOutofCUBOT.html
3.1 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
WorkingwiththeADMINMODETab.html
2.73 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
WorkingwiththeConfigureTab.html
3.39 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
WorkingwiththeDBMANAGERTab.html
4.83 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
WorkingwiththeETLTab.html
8.08 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
WorkingwiththeLogsTab.html
5.94 KB
08/14/2022 11:09:12 AM
rw-r--r--
📄
WorkingwiththeProcessTab.html
7.88 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
WorkingwiththeWorkflowTab.html
4.47 KB
08/14/2022 11:09:07 AM
rw-r--r--
📁
css
-
08/14/2022 11:08:59 AM
rwxr-xr-x
📁
img
-
08/14/2022 11:09:07 AM
rwxr-xr-x
📁
js
-
08/14/2022 11:09:14 AM
rwxr-xr-x
📁
lib
-
08/14/2022 11:08:59 AM
rwxr-xr-x
📄
toc.html
44.18 KB
08/14/2022 11:08:45 AM
rw-r--r--
Editing: HowtoWorkwiththeTransformationSc.html
Close
<html> <head> <title>How to Work with the Transformation Screen</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta name="generator" content="HelpNDoc Standard Edition 3.6.0.345"> <link type="text/css" rel="stylesheet" media="all" href="css/reset.css" /> <link type="text/css" rel="stylesheet" media="all" href="css/base.css" /> <link type="text/css" rel="stylesheet" media="all" href="css/hnd.css" /> <!--[if lte IE 8]> <link type="text/css" rel="stylesheet" media="all" href="css/ielte8.css" /> <![endif]--> <style type="text/css"> #topic_header { background-color: #EFEFEF; } </style> <script type="text/javascript" src="js/jquery.min.js"></script> <script type="text/javascript" src="js/hnd.js"></script> <script type="text/javascript"> if (top.frames.length == 0) { var sTopicUrl = top.location.href.substring(top.location.href.lastIndexOf("/") + 1, top.location.href.length); top.location.href = "CUBOT 9.0 ETL ADMIN GUIDE.html?" + sTopicUrl; } else if (top && top.FrameTOC && top.FrameTOC.SelectTocItem) { top.FrameTOC.SelectTocItem("HowtoWorkwiththeTransformationSc"); } </script> </head> <body> <div id="topic_header"> <div id="topic_header_content"> <h1>How to Work with the Transformation Screen</h1> <div id="topic_breadcrumb"> <a href="WorkingwiththeConfigureTab.html">Working with the Configure Tab</a> ›› </div> </div> <div id="topic_header_nav"> <a href="WorkingwiththeConfigureTab.html"><img src="img/arrow_up.png" alt="Parent"/></a> <a href="HowtoSetPrimaryKeyOptiontoaField.html"><img src="img/arrow_left.png" alt="Previous"/></a> <a href="HowtoManagetheTasks.html"><img src="img/arrow_right.png" alt="Next"/></a> </div> <div class="clear"></div> </div> <div id="topic_content"> <p class="rvps9"><span class="rvts14">How to Work with the Transformation Screen</span></p> <p class="rvps3"><span class="rvts7">Transformation allows you to split data, concatenate it. </span></p> <p class="rvps3"><span class="rvts7">You can apply the transformation functions to the source of information selected in the Transformation screen. The Transformation screen can be used for:</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps17" style="margin-left: 0"><span class="rvts7">Mapping</span></li> <li class="rvps17" style="margin-left: 0"><span class="rvts7">Transformation</span></li> <li class="rvps17" style="margin-left: 0"><span class="rvts7">Validation</span></li> <li class="rvps17" style="margin-left: 0"><span class="rvts7">Data Patching</span></li> <li class="rvps17" style="margin-left: 0"><span class="rvts7">Previewing Output Data </span></li> </ul></ul> <p class="rvps6"><img alt="" style="padding : 1px;" src="lib/Transformation Screen.png"/></p> <p class="rvps16"><a name="Transformation Screen"></a> <span class="rvts23">Transformation Screen</span></p> <p class="rvps3"><span class="rvts7">The Transformation screen consists of the following sections:</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps17" style="margin-left: 0"><span class="rvts7">Transformation: Displays the help option and an option to transform data from source to destination.</span></li> <li class="rvps17" style="margin-left: 0"><span class="rvts7">Source Data Validation: Allows you to validate the source data and the action when the validation fails.</span></li> <li class="rvps17" style="margin-left: 0"><span class="rvts7">Transformation Data Preview: Displays the transformed data.</span></li> <li class="rvps17" style="margin-left: 0"><span class="rvts7">Data Patching: Allows you to make changes in the destination column.</span></li> <li class="rvps17" style="margin-left: 0"><span class="rvts7">Transaction Tables to Patch: Displays the transactions tables that need to be patched.</span></li> </ul></ul> <p class="rvps12"><span class="rvts7"> </span><img alt="" style="padding : 1px;" src="lib/Note icon.png"/><span class="rvts17"> </span><span class="rvts7">Select the check box beside </span><span class="rvts9">User will define scripts for Transformations</span><span class="rvts7"> to allow the user to write scripts.</span></p> <p class="rvps3"><span class="rvts7">In the Transformation section of Transformation screen, do the following:</span></p> <p class="rvps12"><span class="rvts7"> </span><img alt="" style="padding : 1px;" src="lib/Note icon.png"/><span class="rvts17"> </span><span class="rvts7">Select the check box beside </span><span class="rvts9">Disable Transformations</span><span class="rvts7"> to perform the transformations without any mapping. By default, this check box is selected. When a user wants to work in the Transformation screen, deselect the </span><span class="rvts9">Disable Transformation</span><span class="rvts7"> check box.</span></p> <p class="rvps13"><span class="rvts7">1. Click help icon </span><img alt="" style="padding : 1px;" src="lib/help icon.png"/><span class="rvts7"> , to view the supported Transformation rules. The Transformation Rules </span></p> <p class="rvps13"><span class="rvts7"> are displayed in the following figure.</span></p> <p class="rvps15"><img width="598" height="92" alt="" style="padding : 1px;" src="lib/Supported Transformation Rules.png"/></p> <p class="rvps16"><span class="rvts23">Supported Transformation Rules</span></p> <p class="rvps13"><span class="rvts7">2. Select the check box in the Y/N column, in the row of the selected source to send data from </span></p> <p class="rvps13"><span class="rvts7"> source field to destination.</span></p> <p class="rvps13"><span class="rvts7">3. From the </span><span class="rvts9">Source</span><span class="rvts7"> drop-down list, select the source field.</span></p> <p class="rvps13"><span class="rvts7">4. From the </span><span class="rvts9">Destination</span><span class="rvts7"> drop-down list, select the destination field.</span></p> <p class="rvps13"><span class="rvts7">5. Click </span><span class="rvts9">Apply</span><span class="rvts7"> to transform data from source field to destination field.</span></p> <p class="rvps3"><span class="rvts7">In the Source Data Validation section, do the following:</span></p> <p class="rvps13"><span class="rvts7">6. Deselect the </span><span class="rvts9">Disable Data Validation</span><span class="rvts7"> check box when the user wants to validate the data.</span></p> <p class="rvps13"><span class="rvts7"> By default this check box is selected.</span></p> <p class="rvps13"><span class="rvts7">7. From the </span><span class="rvts9">Validation Rule</span><span class="rvts7"> drop-down list, select the function that you need to apply to the selected field. </span></p> <p class="rvps13"><span class="rvts7"> The selected function is displayed in the text box.</span></p> <p class="rvps13"><span class="rvts7">8. From the </span><span class="rvts9">Action if validation fails</span><span class="rvts7"> drop-down list, select the type of action to be performed when </span></p> <p class="rvps13"><span class="rvts7"> the validation rule fails. The selected action is displayed in the text box.</span></p> <p class="rvps13"><span class="rvts7">9. Click </span><span class="rvts9">Apply</span><span class="rvts7"> to validate the source data.</span></p> <p class="rvps3"><span class="rvts7">In the Transformed Data Preview section, do the following:</span></p> <p class="rvps13"><span class="rvts7">10. Click the preview icon </span><img alt="" style="padding : 1px;" src="lib/preview icon.png"/><span class="rvts7"> or the Preview link to view the transformed data. The transformed </span></p> <p class="rvps13"><span class="rvts7"> data is displayed in a table.</span></p> <p class="rvps3"><span class="rvts7">In the Data Patching section, do the following:</span></p> <p class="rvps13"><span class="rvts7">11. In the </span><span class="rvts9">Patch Value</span><span class="rvts7"> text box, type the patch value.</span></p> <p class="rvps12"><span class="rvts17"> </span><img alt="" style="padding : 1px;" src="lib/Note icon.png"/><span class="rvts17"> </span><span class="rvts7">Data Patching is to patch the data into a dimension table from the selected transaction table. The primary key of a master table is used for data patching. The default patch values (other than the primary key) are specified in the Data Patching section of the Transformation screen. The transaction table to patch is specified in the Transaction Tables to Patch section of the Transformation screen.</span></p> <p class="rvps13"><span class="rvts7">12. Click </span><span class="rvts9">Apply</span><span class="rvts7"> to save the changes made.</span></p> <p class="rvps13"><span class="rvts7">13. You can now:</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Click </span><span class="rvts9">Back</span><span class="rvts7"> to make changes in the </span><a class="rvts11" href="HowtoSelectaDestinationTableScre.html#Destination Table Screen">Destination Table screen</a><span class="rvts7">. </span></li> </ul></ul></ul> <p class="rvps31"><span class="rvts7">Or</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Click </span><span class="rvts9">Next</span><span class="rvts7">. The </span><a class="rvts11" href="HowtoManagetheTasks.html#Task For Store Name Screen">Task For: <store name>screen</a><span class="rvts7"> is displayed.</span></li> </ul></ul></ul> <p class="rvps31"><span class="rvts7">Or</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Click</span><span class="rvts9"> Cancel</span><span class="rvts7"> to undo the changes made.</span></li> </ul></ul></ul> </div> <div id="topic_footer"> <div id="topic_footer_content"> Copyright © 2013 Robust Designs India Private Ltd. All Rights Reserved.</div> </div> </body> </html>