Please want to ask, kettle in between the two heterogeneous table data extraction, can achieve a general assignment? Such as: A field name in the table, the age, the add, extract the corresponding B B table to table MZ, NL, DZ. Want to achieve the batch operation, without A list A table yourself mapping in the kettle,

CodePudding user response:

You don't own corresponding, how do you know your mapping relationship, it is a random, estimates may not be right,

CodePudding user response:

Really can't, you have to give him the rules

CodePudding user response:

Uh, excuse me everybody, can achieve the following ideas: for example, can use a table C, two fields to preserve their mapping relationship, (name, MZ), (the age, NL), (add, DZ); And then to read from C to field mapping, through a series of operations in the kettle realizes the dynamic between the two heterogeneous table data extraction of general homework (batch extraction)?

CodePudding user response:

Uh, excuse me, can you implement the following ideas: for example, can use a table C, two fields to preserve their mapping relationship, (name, MZ), (the age, NL), (add, DZ); And then to read from C to field mapping, through a series of operations in the kettle realizes the dynamic between the two heterogeneous table data extraction of general homework (batch extraction)?

CodePudding user response:

reference 4 floor Js_Elaine response:

well, so excuse me, can realize the following ideas: for example, can use a table C, two fields to preserve their mapping relationship, (name, MZ), (the age, NL), (add, DZ); And then to read from C to field mapping, through a series of operations in the kettle realizes the dynamic between the two heterogeneous table data extraction of general homework (batch extraction)?

As if no

CodePudding user response:

Possible, kettle task is an XML file itself, but you have to write a program, according to your map, to generate the task file
As if also is in the table input components of SQL map is more convenient and direct

CodePudding user response:

Meet the same problem with you, convenient ask you is how to solve, because it is more table between the data extraction, so can't do in table output field mapping, you solved