I would like to know if it’s possible in DQA (or any other Ataccama tool) to having flat file profile generate “CREATE TABLE” statement – any general ANSI one or specific for Oracle, SQL Server or DB2. Any idea?
I’m not sure I can understand what you mean. Can you give more details, please? Are you talking about the profiler? What do you want to do with it?
Sorry for being not precise enough!
Generally the idea is to:
- create a profile
- having profile create sql CREATE TABLE (any database)
- execute sql in database
- then load the data
So ideally would be having profile create a DDL with proper data types.
you can do it with the Profiling step. If you enable Drill-through there, it will automatically create tables for you.
The problem will be that table and column names will be generated automatically, so you will need to rename them. Also it’s better to switch off the mask for the input, otherwise for each input column you will have an additional column for the mask.
Thanks for the response. It’s quite close to what I wanted to get indeed.
Solution has some limitations:
- columns names
- data types which differs from profile and seems to be quite generic
But anyway it seems to be interesting option.