.png)
Wednesday, July 24, 2024
Query to get boundary values - DB2
SELECT '["' ||
Max(LONGDESCRIPTIONID) || '"],' /*, COUNT(*)*/
FROM ( SELECT LONGDESCRIPTIONID,
NTILE(30) OVER (ORDER BY LONGDESCRIPTIONID) AS nt FROM MAXIMO.LONGDESCRIPTION )
AS subquery
GROUP BY nt
ORDER BY nt;
AWS DMS task boundary for DB2 -AWS
{
"rules": [
{
"rule-type": "transformation",
"rule-id": "635020703",
"rule-name": "635020703",
"rule-target": "table",
"object-locator": {
"schema-name": "IMOO",
"table-name": "LONGDESCRIPTION"
},
"rule-action": "rename",
"value": "LONGDESCRIPTION_DMS",
"old-value": null
},
{
"rule-type": "selection",
"rule-id": "634996098",
"rule-name": "634996098",
"object-locator": {
"schema-name": "MAXIMO",
"table-name": "LONGDESCRIPTION"
},
"rule-action": "include",
"filters": []
},
{
"rule-type": "table-settings",
"rule-id": "10017",
"rule-name": "10017",
"object-locator": {
"schema-name": "MAXIMO",
"table-name": "LONGDESCRIPTION"
},
"parallel-load": {
"type": "ranges",
"columns": [
"LONGDESCRIPTIONID"
],
"boundaries": [
[
"610614"
],
[
"2138943"
],
[
"68086972"
],
[
"69076217"
],
[
"70370782"
],
[
"71437915"
],
[
"156280074"
],
[
"181021018"
],
[
"181875346"
],
[
"182522701"
],
[
"183057527"
],
[
"232091413"
],
[
"232639702"
],
[
"233198798"
],
[
"233762154"
],
[
"234272071"
],
[
"234831446"
],
[
"235343041"
],
[
"236045262"
],
[
"236643877"
],
[
"237186110"
],
[
"237706781"
],
[
"238246770"
],
[
"238747339"
],
[
"240326830"
],
[
"240846182"
],
[
"241419872"
],
[
"242068765"
],
[
"242640651"
],
[
"243387629"
]
]
},
"rule-action": "include",
"filters": []
}
]
}
Subscribe to:
Posts (Atom)