DSXchange

We will use IA as a DQ monitoring and reporting tool. The main idea is to be able to reuse jobs created in one environment - say in dev - and easily "scale" them to production.

Thanks, Jonathan. The concern was that the IA interface may be too convoluted for the Data Steward who may be a business end-user. And yes, the IA output may in fact be used downstream in ETL. So we're hoping to output directly to a table. Is there a way to do that, rather than having to do a second...

Thanks, Vincent. Yes, I've done it that way before, but now this new project wants to use the IADB directly, if possible.

Thank you so much, Jonathan! That article proved quite informative.

Here is my understanding: after IA completes an analysis, the results are stored in the analysis database, IADB by default. But can I send the results to a table of my own choosing, say something like INVALID_TRANSACTION_CUSTOMERIDS? My reason for this is so I can deliver such an output table to a d...

Thanks, cdp. No I haven't, but will look at IS Manager. Is it an add-on, i.e., not free?

For now though, my requirement is simply to move/reuse jobs between projects within the same product, IA.

How do I copy jobs from one project to another? Is there an export/import feature, like in DS?

How do you use IA for different environments, e.g., production, development, test? I understand IA, and all of IS for that matter, is projects-based. So is that it? Have a DEV project that connects to development, PROD to production, etc?

I am new at a project that wants to access and use the results of any IA analysis. For instance, after a referential integrity analysis, we may want to link invalid FKs to another table. Has anyone out there done something like this and can give me guidance?

Thanks in advance.

I am facing the same situation here. I have a date type field. What is the syntax for QUARTER.TAG? Is it expecting a date type or internal? I am currently running a server job and the first lines in the job log in Director is a warning that QUARTER.TAG was passed a non-numeric value. Will the job st...

Can anyone please explain what this Prefix is all about? Why does DS put it there? And why does it cause problems?

We just had IA 8.1.2 installed.

I can run RI, but not view its results. After running RI, shouldn't the View Referential Integrity option be visible? It is still greyed out, even after running RI.

Thanks in advance.

UPDATE: Installation issues were resolved which in turn resolved this issue.

Did those, Ray, but I think I have found a round-about way to RI/FKA (not as the documentation says, i.e., click Investigate, Key and Relationship Analysis). Instead, I clicked on Investigate, Key and Cross-Domain, then selected the base column, paired column, and found the RI space. Again, the menu...

Thanks for the welcome and response. Terminologies may have been changed between versions. "Table Analysis" is a concept that doesn't seem to exist anymore in 8.x. I had done Column Analysis on all tables and columns, which I believe is a foundation for many other analyses. Can you kindly ...

We have a brand new install of IS and having issues. I want to conduct a referential integrity/FK analysis in IA. After doing Column Analysis and XDomain, the option Key and Relationship Analysis is not visible when I click on Investigate.

Using IA 8.1.1.

Thanks in advance.