DSXchange

Ernie and Gurus, For the benefit of me and other beginners could you please outline the steps for Data Lineage. I have read through all the posts but there is bits and pieces of information. There is no step by step approach listed anywhere. To keep this discussion simple, it would be great if we ca...

Thanks Ray. I was looking at the frequency report. There are four columns in the report. 1) qsFreqValue 2) qsFreqCounts 3) qsFreqColumnId 4) qsFreqHeaderFlag Column 1 is quite obvious I think, it is the value of the column. Second is the count, but has following value for instance. 00000006 00000000...

Gurus,

I am conversant with Standarize part of QS, but I am new to the Match piece. I want to know why someone would use Match Frequency. What is the significance in terms of further processing that happens.

Thanks

Ernie and other helpful folks,

Could you please let me if Import and Export Manager client ships with InfoSphere software and if yes would I use this tool to import Cognos reports in to Metadata repository.

Thanks

[quote="eostic"]BG doesn't not support inheritance. It is not an ontology....however, you can do very creative things with the relationships that are available...such as Synonyms, Related Terms, and Assigned Assets. BG supports URLs, so you can point to any url where you have a Word docume...

[quote="vmcburney"]I went looking for Business Glossary threads and found posts spread across half a dozen different forums. Can we get a new combined Business Glossary and FastTrack forum?[/quote] Vinceny I have couple of questions on BG, some very basic ones..... 1) Does BG support inher...

No - there will not be 2 rows which will update the same dimension row. Let me try that option and see if it works. You can do this by collecting all the inserts in a dataset in the first job. This is necessary because if you insert and update in the same job you could potentially be updating the n...

Ernie, When you say Data file is this a sequential file? If it is how would you create a table def out of the sequential file schema? I know you can manually type it or use the orchestrate utility in DS. Assuming that you get the Tab def by one of the above methods in DS, then you right click and cr...

Ernie, Can you throw some light on following questions. 1) How a shared file metadata is imported in to common repository. 2) If you are doing lineage, is DS and Extension mapping the only way construct the lineage. 3) From what I have read, lineage seems to be the biggest use with WB. Is there anyt...

Thanks Ernie. So either way, DS data lineage or Extension mapping business lineage, it gives out the metadata that was discovered using a DS job or Extension mapping but will not talk to BG and display the corresponding business terms. Did I understand this correctly? I guess where I am getting at i...

[quote="eostic"]Start here.... since we were discussing it, I decided to put an entry into my blog.... http://dsrealtime.wordpress.com/2010/06/24/data-lineage-vs-business-lineage/ You'll need to at least be on 8.1.1, which came out in June of 2009. This release allows you to create what we...

Ernie,

Could you guide me with the Data Lineage for a shared table to a shared table.

How can I get the Data Lineage to be working.

Thanks

[quote="eostic"]a) We assume that you have 8.1.2 of BG and Metadata Workbench installed. b) We assume you have working "data" lineage that goes from, perhaps, a Shared Table as a source...thru a DataStage Job...and into another Shared Table as a target. [if not, let's start anoth...

[quote="eostic"]In 8.1.2 there is a feature called Business Lineage.... it is primarily designed for Business Glossary, but is visible also in Workbench if you also have the BG user role. It's a "higher" level view of lineage...one that includes only the data resources (sources, ...

[quote="eostic"]They become critical for data lineage when you want to connect DataStage Jobs to "other" software, other artifacts and other information....such as profiling details uncovered by Information Analyzer and Discovery, Cognos reports and Packages, or models imported f...