Data Cleansing

pinkstondevin May 9, 2013 9:26 AM

Hello,

I'm reading through the Admin API and wondering what the best route would be to return data in a csv/json form that could be exported to a data cleansing solution. For instance if i have a vdb with a table i would like to cleanse, what is the best route to return data in csv/json format that I could pass to our cleansing solution?

Thank you!

1. Re: Data Cleansing

shawkins May 9, 2013 10:46 AM (in response to pinkstondevin)

Starting with 8.3 you can produce JSON using the jsonArray_Agg, jsonArray, and jsonObject functions - https://docs.jboss.org/author/display/TEIID/JSON+Functions and https://docs.jboss.org/author/display/TEIID/Expressions

Otherwise to produce CSV, you'll likely want to use TEXTAGG - https://docs.jboss.org/author/display/TEIID/Expression
Actions
2. Re: Data Cleansing

pinkstondevin May 9, 2013 1:07 PM (in response to shawkins)

Thank you Steven!
Actions

Go to original post