schema file

[apkselvam]

Hi all,

I have a scenario to extract multiple files with variable columns and load in to a database. While loading in to database, at run time it has to create a table with source file structure.
For ex, 2 different file with different columns should create 2 tables with same src structure and load the data.

First time am trying with schema file, can someone help me on,
1) how to prepare a schema file,
2) How job understand the file name and its metadata from schema at runtime and
3) how do we pass the same file name to create a table.

Thanks in advance
Selysa

[abhijain]

Hi, there are already replies available on the forum for your query.
Do search, before posting any of your query.


Hope this helps you -

viewtopic.php?t=131351&highlight=schema+file

[apkselvam]

[quote="abhijain"]Hi, there are already replies available on the forum for your query.
Do search, before posting any of your query.


Hope this helps you -

[url]viewtopic.php?t=131351&highlight=schema+file[/url][/quote]

Hi Abhijain, Thanks for your reply! I searched in forum still i didnot find answers to my questions. I prepared a schema file from table definition, do I need to keep all 5 schema files(consider I have 5 diff src file) in one file or diff file?

[chulett]

Different files and then use a job parameter to bring in the right one.