I have a One Data table created by importing data from a .csv file. I need to use some of the data in this table by joining it with an existing Catalog Item by creating a SQL Catalog Item so that I can implement some rules on it. Where you select the source when starting to create the SQL Catalog Item I do not get an option to select oneData. Is it even possible to do this in OneWeb?
Solved
Join a ONE Data table with a Catalog Item in OneWeb
- Universe Traveller
- 3 replies
Best answer by rafeeq.durowoju
Hey
Might I ask which version you are using?
I’ve just tried what you described by creating a VCI, adding a DQ rule to it, both at CI level, and at Monitoring Project (MP) level.
I then made a change to the VCI by adding a new column, updated, and published all within ONE Desktop. When I return to the web application, I can see my new column and the DQ rule is still applied both at the CI level and at the MP level. I am able to run the DQ evaluation successfully on my VCI without any additional changes. All of this was tested in v15.2.
Update:
Having tested the same in v14.5.0, I am seeing the behavior you described regarding the DQ mappings being removed when the VCI changes.
Depending on your version/deployment type, I would recommend exploring your options regarding upgrading to version 15 where this issue seems to have been resolved.
Regards,
Rafeeq
- Ataccamer
- 13 replies
Hey Mel,
If you want to join two catalog items coming from differing sources, you would do this by using a VCI, within which you would use the Catalog Item Reader step to read the data from both CIs and join them together within your ONE Desktop plan. More information here.
Regards,
Rafeeq
- Universe Traveller
- 3 replies
Thanks
- Ataccamer
- 13 replies
- Answer
Hey
Might I ask which version you are using?
I’ve just tried what you described by creating a VCI, adding a DQ rule to it, both at CI level, and at Monitoring Project (MP) level.
I then made a change to the VCI by adding a new column, updated, and published all within ONE Desktop. When I return to the web application, I can see my new column and the DQ rule is still applied both at the CI level and at the MP level. I am able to run the DQ evaluation successfully on my VCI without any additional changes. All of this was tested in v15.2.
Update:
Having tested the same in v14.5.0, I am seeing the behavior you described regarding the DQ mappings being removed when the VCI changes.
Depending on your version/deployment type, I would recommend exploring your options regarding upgrading to version 15 where this issue seems to have been resolved.
Regards,
Rafeeq
1 person likes this
- Universe Traveller
- 3 replies
I appreciate that you are testing and trying to help so much. I have 14.5.2 Desktop version but 14.5.0 Web version - so probably that is where my problem comes in. I will request update to the Web version. For now I have loaded the OneData data into a Snowflake table and things seem to be working fine. I will try this again with version update.
Thank you again
Mel
1 person likes this
Reply
Most Liked this week
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.