tdt 3.6, load distinct values
|
View:
New views
2 Messages
—
Rating Filter:
Alert me
|
 |
tdt 3.6, load distinct values
by Tom Kast-3
::
Rate this Message:
Some parts of this message have been removed.
Learn more about Nabble's security policy.
how do you set up an import definition to only insert
distinct rows from the source db? here is my import definition: <valueColumns> <valueColumn
sourceColumnName="ADMIN_ZONE_LEVEL"
targetTableName="TB_ZONE_DIM"
targetColumnName="ADMIN_ZONE_LEVEL" targetTableID="0"
valueMode="Overwrite"/> <valueColumn
sourceColumnName="AUTHORITY_FIPS"
targetTableName="TB_ZONE_DIM"
targetColumnName="AUTHORITY_FIPS" targetTableID="0"
valueMode="Overwrite"/> (…) <valueColumn sourceColumnName="ZONE_DIM_KEY"
targetTableName="TB_ZONE_DIM"
targetColumnName="ZONE_DIM_KEY" targetTableID="0"
valueMode="Key"/> </valueColumns> <tables> <table tableName="TB_ZONE_DIM"
tableID="0" insert="true" tableMode="Query"
oidLogic="false"/> </tables> Regards, Thomas L. Kast Project Lead, Reports Sabrix, Inc. Office Phone: 503 924 4921 x189 E-mail: tom.kast@... This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information that is protected from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message and any attachments. -- You receive this message as a subscriber of the octopus@... mailing list. To unsubscribe: mailto:octopus-unsubscribe@... For general help: mailto:sympa@...?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws |
|
|
RE: tdt 3.6, load distinct values
by Sinisa Milosevic
::
Rate this Message:
Some parts of this message have been removed.
Learn more about Nabble's security policy.
Hi, You can use selectStatement attribute to
define source table and use SQL statement: select distinct…. I hope it helps. Regards, -----Original Message----- how do you set up an import
definition to only insert distinct rows from the source db? here is my
import definition: <valueColumns> <valueColumn
sourceColumnName="ADMIN_ZONE_LEVEL"
targetTableName="TB_ZONE_DIM"
targetColumnName="ADMIN_ZONE_LEVEL" targetTableID="0"
valueMode="Overwrite"/> <valueColumn
sourceColumnName="AUTHORITY_FIPS"
targetTableName="TB_ZONE_DIM"
targetColumnName="AUTHORITY_FIPS" targetTableID="0"
valueMode="Overwrite"/> (…) <valueColumn
sourceColumnName="ZONE_DIM_KEY" targetTableName="TB_ZONE_DIM"
targetColumnName="ZONE_DIM_KEY" targetTableID="0"
valueMode="Key"/> </valueColumns> <tables> <table
tableName="TB_ZONE_DIM" tableID="0" insert="true"
tableMode="Query" oidLogic="false"/> </tables> Regards, Thomas L. Kast Project Lead, Reports Sabrix, Inc. Office Phone: 503 924 4921 x189 E-mail:
tom.kast@... This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information that is protected from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message and any attachments. -- You receive this message as a subscriber of the octopus@... mailing list. To unsubscribe: mailto:octopus-unsubscribe@... For general help: mailto:sympa@...?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws |
| Free embeddable forum powered by Nabble | Forum Help |
