194.6.0.55300genpref/savepref/choices21disppref/fieldLabel0disppref/valueLabel0disppref/quotesymb0disppref/realdisp0genpref/savepref/data1genpref/savepref/library1genpref/savepref/datadirC:\DOCUME~1\ataieb24\LOCALS~1\Tempgenpref/memmgr/enabled1genpref/memmgr/auto1genpref/memmgr/minmem200genpref/memmgr/maxmem250connpref/connupdate0execpref/formula/critical0genpref/savepref/savelengthTRANS308841693120090304131511Transformation 1Iteration7BoolOptionInfoBitmap7ErrorFilterGroupListSH2dbufr7011348549Connection7ConnectionNameCONNECTION1TableNameDescription7

SH60SH100SH110SH130SH170SH190SH230

SH6Sélection22331048543OutputTableInfo7TableName5InputJoin4InputSort4Selection7FormulaSelection5OutputSelection7FieldSelection7FieldSelection3nomagesalaireFieldChoosen2010Parameters1Distinct21OutputSort4Description7

SH90

SH9Créer champs33331648544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code5Type5FormulaToCreate5Label5Description5Category5FieldToCopy5CreateField47FormulaNameCodeFormulaTyperealFormulaToCreate[age]5[age]FieldLabelCodeFieldDescriptionFieldCategoryFieldToCopy7FormulaNameTypeFormulaTypesymbolicFormulaToCreate"Integer"5"Integer"FieldLabelFieldDescriptionFieldCategoryFieldToCopy7FormulaNameFormulaFormulaTypesymbolicFormulaToCreateSTRCAT("IF([age]==\"",[age],"\",\"1\",\"0\")")5STRCAT("IF([age]==\"",[age],"\",\"1\",\"0\")")FieldLabelFieldDescriptionFieldCategoryFieldToCopyInputJoin4InputSort4OutputSelection7FieldSelection7FieldSelection3ageFieldChoosen20Parameters1Distinct20OutputSort4Description7Description

SH10-1

SH10Créer champs41343148544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code[Code]5[Code]Type[Type]5[Type]FormulaToCreate[Formula]5[Formula]Label5Description5Category5FieldToCopy5CreateField4InputJoin4InputSort4OutputSelection7FieldSelectionDistinct20OutputSort4Description7

SH140

SH11Sélection24017048543OutputTableInfo7TableName5InputJoin4InputSort4Selection7FormulaSelection5OutputSelection7FieldSelection7FieldSelection3nomagesalaireFieldChoosen2001Parameters1Distinct21OutputSort4Description7

SH120

SH12Créer champs35017048544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code5Type5FormulaToCreate5Label5Description5Category5FieldToCopy5CreateField47FormulaNameCodeFormulaTyperealFormulaToCreate[salaire]5[salaire]FieldLabelCodeFieldDescriptionFieldCategoryFieldToCopy7FormulaNameTypeFormulaTypesymbolicFormulaToCreate"Integer"5"Integer"FieldLabelFieldDescriptionFieldCategoryFieldToCopy7FormulaNameFormulaFormulaTypesymbolicFormulaToCreateSTRCAT("IF([salaire]==",[salaire],",\"1\",\"0\")")5STRCAT("IF([salaire]==",[salaire],",\"1\",\"0\")")FieldLabelFieldDescriptionFieldCategoryFieldToCopyInputJoin4InputSort4OutputSelection7FieldSelection7FieldSelection3ageFieldChoosen20Parameters1Distinct20OutputSort4Description7Description

SH13-1

SH13Créer champs47022048544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code[Code]5[Code]Type[Type]5[Type]FormulaToCreate[Formula]5[Formula]Label5Description5Category5FieldToCopy5CreateField4InputJoin4InputSort4OutputSelection7FieldSelection7FieldSelection3nomagesalaireFieldChoosen2000Parameters1Distinct20OutputSort4Description7

SH141

SH14Juxtaposition549369485438OutputTableInfo7TableName5Juxtaposition7OnlyRecordsFirstTable200Description7

SH150

SH15Créer champs66038048544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code5Type5FormulaToCreate5Label5Description5Category5FieldToCopy5CreateField47FormulaNameage!=30 et salaire=2000FormulaTypeintegerFormulaToCreate AND( NOT([age]="30"),[salaire]=2000 )5 AND( NOT([age]="30"),[salaire]=2000 )FieldLabelFieldDescriptionFieldCategoryFieldToCopyInputJoin4InputSort4OutputSelection7FieldSelection7FieldSelection3nomagesalaire243040100014002000FieldChoosen2111000000Parameters1Distinct20OutputSort4Description7

SH160

SH16Sélection73936948543OutputTableInfo7TableName5InputJoin4InputSort4Selection7FormulaSelection[age!=30 et salaire=2000]==15[age!=30 et salaire=2000]==1OutputSelection7FieldSelection7FieldSelection3nomagesalaireage!=30 et salaire=2000FieldChoosen21110Parameters1Distinct20OutputSort4Description7

SH17Binarisation160550485414Binarisation7FormulaTypesymbolicFormulaToCreate"1"5"1"SecondFormula"0"5"0"MaxNumber32FieldChoosenageCodeFieldToJoinFirstTablenomOutputTableInfo7TableName5InputSort4OutputSelection7FieldSelectionDistinct20OutputSort4Description7

SH200

SH19Binarisation159619485414Binarisation7FormulaTypesymbolicFormulaToCreate"1"5"1"SecondFormula"0"5"0"MaxNumber32FieldChoosensalaireCodeFieldToJoinFirstTablenomOutputTableInfo7TableName5InputSort4OutputSelection7FieldSelectionDistinct20OutputSort4Description7

SH201

SH20Juxtaposition299569485438OutputTableInfo7TableName5Juxtaposition7OnlyRecordsFirstTable200Description7Description

SH210

SH21Créer champs43057048544OutputTableInfo7TableName5CreateFieldSpecialEntry7Code5Type5FormulaToCreate5Label5Description5Category5FieldToCopy5CreateField47FormulaNameage!=30 et salaire=2000FormulaTypeintegerFormulaToCreate AND( NOT([age_30]="1"),[salaire_2000]="1" )5 AND( NOT([age_30]="1"),[salaire_2000]="1" )FieldLabelFieldDescriptionFieldCategoryFieldToCopyInputJoin4InputSort4OutputSelection7FieldSelection7FieldSelection3nomagesalaire243040100014002000FieldChoosen2111000000Parameters1Distinct20OutputSort4Description7

SH231

SH22Sélection68056048543OutputTableInfo7TableName5InputJoin4InputSort4Selection7FormulaSelection[age!=30 et salaire=2000]==15[age!=30 et salaire=2000]==1OutputSelection7FieldSelection7FieldSelection3nomage!=30 et salaire=2000age_24age_30age_40nom2salaire_1000salaire_1400salaire_2000agesalairenom22FieldChoosen2100000000110Parameters1Distinct20OutputSort4Description7

SH23Juxtaposition529499485438OutputTableInfo7TableName5Juxtaposition7OnlyRecordsFirstTable200Description7

SH220

CONNECTION1Connection 100038DBUFR1dbufrdbufr00344610100PERSONNEPERSONNE110defaulttransformationInfo7TRANS3088416931200903041315117graphicalAnnotation7graphicalOrder3SH2SH6SH9SH10SH11SH12SH13SH14SH15SH16SH17SH19SH20SH21SH22SH23groupId2-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1groupIsMaster20000000000000000windowState7TRANS3088416931200903041315117windowPos200158384windowCmd3windowOrder3TRANS308841693120090304131511UniqueIdlib27020152142009030413151172069551353571oracle test2.ASB