Differences between defined, inferred, and chosen values IA.
-
- Participant
- Posts: 10
- Joined: Wed Jan 26, 2011 8:09 am
- Location: Hyderbad
Differences between defined, inferred, and chosen values IA.
I am new to IA, Explanation Needed for defined, inferred, and chosen data types values in Info Analyzer.please provide with some Examples
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
Defined - a generic form of the type taken from the source metadata.
Inferred - when column analysis is run, it looks at every distinct values and tries to find the smallest data type it can successfully fit in. The smallest type that they could all successfully fit in will be the inferred type for the column.
Chosen - when you review the results, you get to go along with the inferred data type, or pick another. This might (ie can't remember for sure) cause values that can't be converted to the chosen type to now be considered invalid values by IA.
Inferred - when column analysis is run, it looks at every distinct values and tries to find the smallest data type it can successfully fit in. The smallest type that they could all successfully fit in will be the inferred type for the column.
Chosen - when you review the results, you get to go along with the inferred data type, or pick another. This might (ie can't remember for sure) cause values that can't be converted to the chosen type to now be considered invalid values by IA.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 10
- Joined: Wed Jan 26, 2011 8:09 am
- Location: Hyderbad
Thanks for you Info
[quote="stuartjvnorton"]Defined - a generic form of the type taken from the source metadata.
Inferred - when column analysis is run, it looks at every distinct values and tries to find the smallest data type it can successfully fit in. The smallest type that they could all successfully fit in will be the inferred type for the column.
Chosen - when you review the results, you get to go along with the inferred data type, or pick another. This might (ie can't remember for sure) cause values that can't be converted to the chosen type to now be considered invalid values by IA.[/quote]
Thanks stuart, It means Both Inferred and chosen both are same if we wont do any changes of your data...
Inferred - when column analysis is run, it looks at every distinct values and tries to find the smallest data type it can successfully fit in. The smallest type that they could all successfully fit in will be the inferred type for the column.
Chosen - when you review the results, you get to go along with the inferred data type, or pick another. This might (ie can't remember for sure) cause values that can't be converted to the chosen type to now be considered invalid values by IA.[/quote]
Thanks stuart, It means Both Inferred and chosen both are same if we wont do any changes of your data...