代码改变世界

PDI的steps:(10:table input)

2013-05-26 21:34  很大很老实  阅读(301)  评论(0编辑  收藏  举报

id:TableInput

分类:输入

描述:

通过connection和sql,从数据库里读取信息。

Options

OptionDescription
Step name Name of the step;the name has to be unique in a single transformation
Connection The database connection from which to read data
SQL The SQL statement used to read information from the database connection. You can also click Get SQL select statement... to browse tables and automatically generate a basic select statement.
Enable lazy conversion When enables, lazy conversion avoids unnecessary data type conversions and can result in a significant performance improvements.
Replace variables in script? Enable to replace variables in the script; this feature was provided to allow you to test with or without performing variable substitutions.
Insert data from step Specify the input step name where Pentaho? an expect information to come from. This information can then be inserted into the SQL statement. The locators where Pentaho? inserts information is indicated by ? (question marks).
Execute for each row? Enable to perform the data insert for each individual row.
Limit size Sets the number of lines that is read from the database; zero (0) means read all lines.