Cross Column Analysis in IA

QuestExpert · Post by **QuestExpert** » Mon Dec 13, 2010 5:56 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Dec 13, 2010 6:59 pm

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.

QuestExpert · Post by **QuestExpert** » Thu Dec 16, 2010 1:14 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Dec 16, 2010 3:12 pm

You have selected just these three columns in the base AND in the paired table? How many rows in each table?

QuestExpert · Post by **QuestExpert** » Thu Dec 16, 2010 3:28 pm

These three cols are in the same table (Denormalized),

Do I have to define PK, FK in my table? currently I dont have them defined and all the cols are simple VarChar(),

Could you also tell me how to define Base Table (if I need to) like you mentioned in your last reply.

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Dec 16, 2010 3:52 pm

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.