Hello,
I am using Information Analyzer for data profiling.
I flatten the IMS (Hierarchal) Database
From
Part No | Source | Description
---------- Component Part No | Source | Name
---------------------------------------Installed Part No | Source | Description
TO (in one table, delimiter | )
Part No | Source | Desc | Component Part No | Comp. Source | Comp. Name | Installed Part No | Installed Source | Installed Desc.
Now I want to analyze the data for Parent and Child relationship
Main Parent is 'Part No' its immediate child is 'Component Part No' and grand child is 'Installed Part No'
Question: which analysis do I need to perform and which report shall I run.
I wanted to know
How many Parents (Part No) has 0 child (Component Part No) and 0 grand child (Installed Part No)?
How many are orphan children?
Etc.
Thanks
Cross Column Analysis in IA
-
- Participant
- Posts: 22
- Joined: Tue Mar 13, 2007 10:10 am
Cross Column Analysis in IA
Quest Expert
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm not sure whether or not you've run the Cross Domain analyses on virtual columns but, assuming that you have, then your requirement would seem to me to be one for Foreign Key analysis.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 22
- Joined: Tue Mar 13, 2007 10:10 am
for some reason reason my cross domain analysis is not working.,
what I am doing is: selecting the three columns (Part No, Component Part No, Installed Part No) and then simply clicking on Run Cross Domain Analysis> and after that my IA just keep on clocking for hours and at the end i have to kill the session.
I have run Column Analysis on all the columns in the table, though.
Thanks
what I am doing is: selecting the three columns (Part No, Component Part No, Installed Part No) and then simply clicking on Run Cross Domain Analysis> and after that my IA just keep on clocking for hours and at the end i have to kill the session.
I have run Column Analysis on all the columns in the table, though.
Thanks
Quest Expert
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 22
- Joined: Tue Mar 13, 2007 10:10 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A Cross Domain analysis asks for base and pair. Looks to me like you haven't gotten into that workspace at all. From the INVESTIGATE pillar menu it's the "Key and Cross-Domain Analysis" option.
It is feasible for the base and paired tables to be the same table, if you need to investigate whether a nested relationship exists. You will, of course, find a common domain (always, in this case) but can then proceed to undertake a foreign key analysis which seeks out the one-to-many, many-to-one relationships that characterise primary/foreign keys.
It is feasible for the base and paired tables to be the same table, if you need to investigate whether a nested relationship exists. You will, of course, find a common domain (always, in this case) but can then proceed to undertake a foreign key analysis which seeks out the one-to-many, many-to-one relationships that characterise primary/foreign keys.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.