XML Stage usage to input data from Flat File to RDBMS
Posted: Fri Jan 09, 2004 6:49 am
Hi,
Wanted to know the best approach to a complex problem.
I am expected to flow data from 2 flat files into a huge XSD( XML format which is existing ) in step 1 and flow data from XML stage to RDBMS ( Informix)
my flow is like this:
File 1 and 2 ---> Transformer ---> XML Output (Step 1)
Where I use hash files or seq files at the left side of the transfomer and map the relevant columns to the xsd format which I have imported(this is on the left)
Now for step 2
XML Output -->XML Transformer--> XML Input --->Transformer-->RDBMS tables
I have found that this is not working satisfactorily.
Manuals say that XML input /ouput are to be used ...is there a better way. Can someone comment on their prior experience?
My main stick ups are
1. The file(s) have a number of nulls and missing data
2. The XSD is huge with atleast 70 tables and further column names
3. Is the process route which I am taking correct?
4. Can I use the same for PX?
Has anyone worked with PX and XML?
As I am scheduled for a rush delivery, will be glad if some one can help out!!!
Regards
Srini
Wanted to know the best approach to a complex problem.
I am expected to flow data from 2 flat files into a huge XSD( XML format which is existing ) in step 1 and flow data from XML stage to RDBMS ( Informix)
my flow is like this:
File 1 and 2 ---> Transformer ---> XML Output (Step 1)
Where I use hash files or seq files at the left side of the transfomer and map the relevant columns to the xsd format which I have imported(this is on the left)
Now for step 2
XML Output -->XML Transformer--> XML Input --->Transformer-->RDBMS tables
I have found that this is not working satisfactorily.
Manuals say that XML input /ouput are to be used ...is there a better way. Can someone comment on their prior experience?
My main stick ups are
1. The file(s) have a number of nulls and missing data
2. The XSD is huge with atleast 70 tables and further column names
3. Is the process route which I am taking correct?
4. Can I use the same for PX?
Has anyone worked with PX and XML?
As I am scheduled for a rush delivery, will be glad if some one can help out!!!
Regards
Srini