kettle : json导入数据库问题

Question

将json文件中的数据导入数据库，怎么设置主键，保证数据不丢失
即字典中的键对应的值保证不重复
json格式
{
"body": {
"list": [
{
"qszzsj": "2013-03-24 00:00:00",
"qskqsl": "10",
"qskgs": "1",
"qszl": "10",
"dxsqszl": "10",
"hylx": "农副食品加工业",
"dwlx": "有限责任公司",
"dbsqszl": "0",
"qsfs": "单井"
},
'''
多个字典
'''
]
"total": "202",
"pageNum": "6",
"pageSize": "14"
},
"head": {
"Code": "000000",
"Msg": "请求成功"
}
}

请大神指点？如果人凭经验来判定应该会出错吧

Answer 1

类似 http://blog.csdn.net/u013991521/article/details/52459431
只是加上json解析