Cross Column Analysis in IA
Posted: 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
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