Can we use schema file, if Source stage is a DB2 EE stage?
Posted: Wed Apr 20, 2011 11:31 pm
Hi Folks,
I know that, we can use the schema file if Sequential file is a source. I have a requirement, my source is DB2EE and Target is Sequential file. I have to extract full data from the source tables and needs to load in the file. I have around 100 tables with the same requirement. Instead of creating 100 jobs for 100 tables, I am thinking of using SCHEMA file concept here and create only one generic job parameterise the table name, extract will be simple SELECT * FROM #TABLENAME# and table definition will be sourced from schema file.
My question to DS guru's is, first of all is it possible to do so in DS V 8.5? if not, what will be the alternate approach for the same?
I know that, we can use the schema file if Sequential file is a source. I have a requirement, my source is DB2EE and Target is Sequential file. I have to extract full data from the source tables and needs to load in the file. I have around 100 tables with the same requirement. Instead of creating 100 jobs for 100 tables, I am thinking of using SCHEMA file concept here and create only one generic job parameterise the table name, extract will be simple SELECT * FROM #TABLENAME# and table definition will be sourced from schema file.
My question to DS guru's is, first of all is it possible to do so in DS V 8.5? if not, what will be the alternate approach for the same?