Page 1 of 1

Can IA profile a file?

Posted: Thu Sep 23, 2010 11:45 pm
by truenorth
I have only used IA to profile, i.e., conduct column analysis, etc. on tables. Is IA also capable of profiling a flat file? If so, how?

Posted: Fri Sep 24, 2010 12:40 am
by ray.wurlod
Quite easy. There's an option called Identify Flat File in the Tasks menu when you're in the Import Metadata workspace (from the Home pillar menu). This builds metadata information into a file called QETXT.INI. Apart from that, just identify the parent directory as a data source, and use the Identify Next Level or Identify All Levels options from the import menu. Once identified, just like with tables, you still have to click Import.

Posted: Mon Oct 04, 2010 11:23 pm
by truenorth
Thanks, Ray.