I am using XML input for the first time . I searched the forum, All of them suggested to use a external source stage with ls command. But can anyone tell me what I need to specify in the Columns and format tab of external source stage?
Any reason for not using XML source stage? You can import the metadata for the XML file from the stage. What have you searched on? ls command will give a list of files in a folder. what are you trying to do?
BugFree wrote:Any reason for not using XML source stage? You can import the metadata for the XML file from the stage. What have you searched on? ls command will give a list of files in a folder. what are you trying to do?
In the Source Program you specify the name of the file along with the path name.
example: find PathName -name "Xml File Name " -print
Set the format to default values.
In the columns you specify any name to the column since it conatins only the file name along with the path.
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
I have used the above command, At the output of external source stage I can see the filename along with the path being passed sucessfully, But at the XML Input stage count stays at 0. What could be wrong?
I have created a Server job for the same, I have used source as a folder stage, I was able to extract the data from the xml file. Now I am using the same xpaths in the parallel jobs, But still the problem persists.
In folder stage I have two columns viz. Filename (Varchar 25) and record (LongVarchar 999999). And in XML input stage I am using the records column to fetch the xml data.
But in PX I am mentioning only Filename. So does the XML Input Stage extract the data from the filename/filepath it gets from the external source stage???