|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.pentaho.di.trans.step.BaseStepMeta org.pentaho.di.trans.steps.dimensionlookup.DimensionLookupMeta
public class DimensionLookupMeta
Field Summary | |
---|---|
static String |
CREATION_METHOD_AUTOINC
|
static String |
CREATION_METHOD_SEQUENCE
|
static String |
CREATION_METHOD_TABLEMAX
|
static int |
START_DATE_ALTERNATIVE_COLUMN_VALUE
|
static int |
START_DATE_ALTERNATIVE_NONE
|
static int |
START_DATE_ALTERNATIVE_NULL
|
static int |
START_DATE_ALTERNATIVE_START_OF_TRANS
|
static int |
START_DATE_ALTERNATIVE_SYSDATE
|
static int |
TYPE_UPDATE_DATE_INSERTED
|
static int |
TYPE_UPDATE_DATE_INSUP
|
static int |
TYPE_UPDATE_DATE_UPDATED
|
static int |
TYPE_UPDATE_DIM_INSERT
|
static int |
TYPE_UPDATE_DIM_PUNCHTHROUGH
|
static int |
TYPE_UPDATE_DIM_UPDATE
|
static int |
TYPE_UPDATE_LAST_VERSION
|
static String[] |
typeCodes
|
static String[] |
typeDesc
|
static String[] |
typeDescLookup
|
Fields inherited from class org.pentaho.di.trans.step.BaseStepMeta |
---|
loggingObject, STEP_ATTRIBUTES_FILE |
Constructor Summary | |
---|---|
DimensionLookupMeta()
|
Method Summary | |
---|---|
void |
allocate(int nrkeys,
int nrfields)
|
void |
analyseImpact(List<DatabaseImpact> impact,
TransMeta transMeta,
StepMeta stepMeta,
RowMetaInterface prev,
String[] input,
String[] output,
RowMetaInterface info)
Each step must be able to report on the impact it has on a database, table field, etc. |
void |
check(List<CheckResultInterface> remarks,
TransMeta transMeta,
StepMeta stepinfo,
RowMetaInterface prev,
String[] input,
String[] output,
RowMetaInterface info)
Checks the settings of this step and puts the findings in a remarks List. |
Object |
clone()
Make an exact copy of this step, make sure to explicitly copy Collections etc. |
int |
getCacheSize()
|
int |
getCommitSize()
|
DatabaseMeta |
getDatabaseMeta()
|
String |
getDateField()
|
String |
getDateFrom()
|
String |
getDateTo()
|
String[] |
getFieldLookup()
|
void |
getFields(RowMetaInterface row,
String name,
RowMetaInterface[] info,
StepMeta nextStep,
VariableSpace space)
Gets the fields. |
String[] |
getFieldStream()
|
int[] |
getFieldUpdate()
|
String |
getKeyField()
|
String[] |
getKeyLookup()
|
String |
getKeyRename()
|
String[] |
getKeyStream()
|
Date |
getMaxDate()
|
int |
getMaxYear()
|
Date |
getMinDate()
|
int |
getMinYear()
|
String |
getSchemaName()
|
String |
getSequenceName()
|
SQLStatement |
getSQLStatements(TransMeta transMeta,
StepMeta stepMeta,
RowMetaInterface prev)
Standard method to return one or more SQLStatement objects that the step needs in order to work correctly. |
int |
getStartDateAlternative()
|
static int |
getStartDateAlternative(String string)
|
static String |
getStartDateAlternativeCode(int alternative)
|
static String[] |
getStartDateAlternativeCodes()
|
static String |
getStartDateAlternativeDesc(int alternative)
|
static String[] |
getStartDateAlternativeDescriptions()
|
String |
getStartDateFieldName()
|
StepInterface |
getStep(StepMeta stepMeta,
StepDataInterface stepDataInterface,
int cnr,
TransMeta tr,
Trans trans)
Get the executing step, needed by Trans to launch a step. |
StepDataInterface |
getStepData()
Get a new instance of the appropriate data class. |
RowMetaInterface |
getTableFields()
Gets the table fields. |
String |
getTableName()
|
String |
getTechKeyCreation()
Get the way how the technical key field should be created. |
static String |
getUpdateType(boolean upd,
int t)
|
static int |
getUpdateType(boolean upd,
String ty)
|
static String |
getUpdateTypeCode(boolean upd,
int t)
|
DatabaseMeta[] |
getUsedDatabaseConnections()
This method returns all the database connections that are used by the step. |
String |
getVersionField()
|
String |
getXML()
Produces the XML string that describes this step's information. |
boolean |
isAutoIncrement()
|
boolean |
isPreloadingCache()
|
boolean |
isUpdate()
|
static boolean |
isUpdateTypeWithoutArgument(boolean update,
int type)
|
boolean |
isUsingStartDateAlternative()
|
void |
loadXML(Node stepnode,
List<DatabaseMeta> databases,
Map<String,Counter> counters)
Load the values for this step from an XML Node |
void |
readRep(Repository rep,
ObjectId id_step,
List<DatabaseMeta> databases,
Map<String,Counter> counters)
Read the steps information from a Kettle repository |
void |
saveRep(Repository rep,
ObjectId id_transformation,
ObjectId id_step)
Save the steps data into a Kettle repository |
void |
setAutoIncrement(boolean autoIncrement)
|
void |
setCacheSize(int cacheSize)
|
void |
setCommitSize(int commitSize)
|
void |
setDatabaseMeta(DatabaseMeta database)
|
void |
setDateField(String dateField)
|
void |
setDateFrom(String dateFrom)
|
void |
setDateTo(String dateTo)
|
void |
setDefault()
Set default values |
void |
setFieldLookup(String[] fieldLookup)
|
void |
setFieldStream(String[] fieldStream)
|
void |
setFieldUpdate(int[] fieldUpdate)
|
void |
setKeyField(String keyField)
|
void |
setKeyLookup(String[] keyLookup)
|
void |
setKeyRename(String keyRename)
|
void |
setKeyStream(String[] keyStream)
|
void |
setMaxYear(int maxYear)
|
void |
setMinYear(int minYear)
|
void |
setPreloadingCache(boolean preloadingCache)
|
void |
setSchemaName(String schemaName)
|
void |
setSequenceName(String sequenceName)
|
void |
setStartDateAlternative(int startDateAlternative)
|
void |
setStartDateFieldName(String startDateFieldName)
|
void |
setTableName(String tablename)
|
void |
setTechKeyCreation(String techKeyCreation)
Set the way how the technical key field should be created. |
void |
setUpdate(boolean update)
|
void |
setUseBatchUpdate(boolean useBatchUpdate)
|
void |
setUsingStartDateAlternative(boolean usingStartDateAlternative)
|
void |
setVersionField(String versionField)
|
boolean |
useBatchUpdate()
|
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final int TYPE_UPDATE_DIM_INSERT
public static final int TYPE_UPDATE_DIM_UPDATE
public static final int TYPE_UPDATE_DIM_PUNCHTHROUGH
public static final int TYPE_UPDATE_DATE_INSUP
public static final int TYPE_UPDATE_DATE_INSERTED
public static final int TYPE_UPDATE_DATE_UPDATED
public static final int TYPE_UPDATE_LAST_VERSION
public static final String[] typeDesc
public static final String[] typeCodes
public static final String[] typeDescLookup
public static final int START_DATE_ALTERNATIVE_NONE
public static final int START_DATE_ALTERNATIVE_SYSDATE
public static final int START_DATE_ALTERNATIVE_START_OF_TRANS
public static final int START_DATE_ALTERNATIVE_NULL
public static final int START_DATE_ALTERNATIVE_COLUMN_VALUE
public static String CREATION_METHOD_AUTOINC
public static String CREATION_METHOD_SEQUENCE
public static String CREATION_METHOD_TABLEMAX
Constructor Detail |
---|
public DimensionLookupMeta()
Method Detail |
---|
public String getTableName()
public void setTableName(String tablename)
tablename
- The tablename to set.public DatabaseMeta getDatabaseMeta()
public void setDatabaseMeta(DatabaseMeta database)
database
- The database to set.public boolean isUpdate()
public void setUpdate(boolean update)
update
- The update to set.public boolean isAutoIncrement()
public void setAutoIncrement(boolean autoIncrement)
autoIncrement
- The autoIncrement to set.public void setTechKeyCreation(String techKeyCreation)
techKeyCreation
- which method to use for the creation
of the technical key.public String getTechKeyCreation()
public int getCommitSize()
public void setCommitSize(int commitSize)
commitSize
- The commitSize to set.public String getDateField()
public void setDateField(String dateField)
dateField
- The dateField to set.public String getDateFrom()
public void setDateFrom(String dateFrom)
dateFrom
- The dateFrom to set.public String getDateTo()
public void setDateTo(String dateTo)
dateTo
- The dateTo to set.public String[] getFieldLookup()
public void setFieldLookup(String[] fieldLookup)
fieldLookup
- sets the fields in the dimension to update or retrieve.public String[] getFieldStream()
public void setFieldStream(String[] fieldStream)
fieldStream
- The fields containing the values in the input stream to update the dimension with.public int[] getFieldUpdate()
public void setFieldUpdate(int[] fieldUpdate)
fieldUpdate
- The fieldUpdate to set.public String getKeyField()
public void setKeyField(String keyField)
keyField
- The keyField to set.public String[] getKeyLookup()
public void setKeyLookup(String[] keyLookup)
keyLookup
- The keyLookup to set.public String getKeyRename()
public void setKeyRename(String keyRename)
keyRename
- The keyRename to set.public String[] getKeyStream()
public void setKeyStream(String[] keyStream)
keyStream
- The keyStream to set.public int getMaxYear()
public void setMaxYear(int maxYear)
maxYear
- The maxYear to set.public int getMinYear()
public void setMinYear(int minYear)
minYear
- The minYear to set.public String getSequenceName()
public void setSequenceName(String sequenceName)
sequenceName
- The sequenceName to set.public String getVersionField()
public void setVersionField(String versionField)
versionField
- The versionField to set.public void loadXML(Node stepnode, List<DatabaseMeta> databases, Map<String,Counter> counters) throws KettleXMLException
StepMetaInterface
loadXML
in interface StepMetaInterface
stepnode
- the Node to get the info fromdatabases
- The available list of databases to reference tocounters
- Counters to reference.
KettleXMLException
- When an unexpected XML error occurred. (malformed etc.)public void allocate(int nrkeys, int nrfields)
public Object clone()
StepMetaInterface
clone
in interface StepMetaInterface
clone
in class BaseStepMeta
public static final int getUpdateType(boolean upd, String ty)
public static final String getUpdateType(boolean upd, int t)
public static final String getUpdateTypeCode(boolean upd, int t)
public static final int getStartDateAlternative(String string)
public static final String getStartDateAlternativeCode(int alternative)
public static final String getStartDateAlternativeDesc(int alternative)
public static final String[] getStartDateAlternativeCodes()
public static final String[] getStartDateAlternativeDescriptions()
public static final boolean isUpdateTypeWithoutArgument(boolean update, int type)
public void setDefault()
StepMetaInterface
setDefault
in interface StepMetaInterface
public void getFields(RowMetaInterface row, String name, RowMetaInterface[] info, StepMeta nextStep, VariableSpace space) throws KettleStepException
BaseStepMeta
getFields
in interface StepMetaInterface
getFields
in class BaseStepMeta
row
- the input row metaname
- the nameinfo
- the infonextStep
- the next stepspace
- the space
KettleStepException
- the kettle step exceptionpublic String getXML()
BaseStepMeta
getXML
in interface StepMetaInterface
getXML
in class BaseStepMeta
public void readRep(Repository rep, ObjectId id_step, List<DatabaseMeta> databases, Map<String,Counter> counters) throws KettleException
StepMetaInterface
readRep
in interface StepMetaInterface
rep
- The repository to read fromid_step
- The step IDdatabases
- The databases to referencecounters
- The counters to reference
KettleException
- When an unexpected error occurred (database, network, etc)public void saveRep(Repository rep, ObjectId id_transformation, ObjectId id_step) throws KettleException
StepMetaInterface
saveRep
in interface StepMetaInterface
rep
- The Kettle repository to save toid_transformation
- The transformation IDid_step
- The step ID
KettleException
- When an unexpected error occurred (database, network, etc)public Date getMinDate()
public Date getMaxDate()
public void check(List<CheckResultInterface> remarks, TransMeta transMeta, StepMeta stepinfo, RowMetaInterface prev, String[] input, String[] output, RowMetaInterface info)
StepMetaInterface
check
in interface StepMetaInterface
remarks
- The list to put the remarks in @see org.pentaho.di.core.CheckResultstepinfo
- The stepMeta to help checkingprev
- The fields coming from the previous stepinput
- The input step namesoutput
- The output step namesinfo
- The fields that are used as information by the steppublic RowMetaInterface getTableFields()
BaseStepMeta
getTableFields
in interface StepMetaInterface
getTableFields
in class BaseStepMeta
public SQLStatement getSQLStatements(TransMeta transMeta, StepMeta stepMeta, RowMetaInterface prev)
BaseStepMeta
getSQLStatements
in interface StepMetaInterface
getSQLStatements
in class BaseStepMeta
transMeta
- TransInfo object containing the complete transformationstepMeta
- StepMeta object containing the complete stepprev
- Row containing meta-data for the input fields (no data)
public void analyseImpact(List<DatabaseImpact> impact, TransMeta transMeta, StepMeta stepMeta, RowMetaInterface prev, String[] input, String[] output, RowMetaInterface info)
BaseStepMeta
analyseImpact
in interface StepMetaInterface
analyseImpact
in class BaseStepMeta
impact
- The list of impacts @see org.pentaho.di.transMeta.DatabaseImpacttransMeta
- The transformation informationstepMeta
- The step informationprev
- The fields entering this stepinput
- The previous step namesoutput
- The output step namesinfo
- The fields used as information by this steppublic StepInterface getStep(StepMeta stepMeta, StepDataInterface stepDataInterface, int cnr, TransMeta tr, Trans trans)
StepMetaInterface
getStep
in interface StepMetaInterface
stepMeta
- The step infostepDataInterface
- the step data interface linked to this step. Here the step can store temporary data, database connections, etc.cnr
- The copy nr to gettr
- The transformation infotrans
- The launching transformationpublic StepDataInterface getStepData()
StepMetaInterface
getStepData
in interface StepMetaInterface
public DatabaseMeta[] getUsedDatabaseConnections()
BaseStepMeta
getUsedDatabaseConnections
in interface StepMetaInterface
getUsedDatabaseConnections
in class BaseStepMeta
public String getSchemaName()
public void setSchemaName(String schemaName)
schemaName
- the schemaName to setpublic int getCacheSize()
public void setCacheSize(int cacheSize)
cacheSize
- the cacheSize to setpublic boolean isUsingStartDateAlternative()
public void setUsingStartDateAlternative(boolean usingStartDateAlternative)
usingStartDateAlternative
- the usingStartDateAlternative to setpublic int getStartDateAlternative()
public void setStartDateAlternative(int startDateAlternative)
startDateAlternative
- the startDateAlternative to setpublic String getStartDateFieldName()
public void setStartDateFieldName(String startDateFieldName)
startDateFieldName
- the startDateFieldName to setpublic boolean isPreloadingCache()
public void setPreloadingCache(boolean preloadingCache)
preloadingCache
- the preloadingCache to setpublic boolean useBatchUpdate()
public void setUseBatchUpdate(boolean useBatchUpdate)
useBatchUpdate
- the useBatchUpdate to set
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |