DSXchange

Hi 1) Ensure that target stage was written correctly. Try to veiw data. 2) Check the format tab, Ensure that the job in which the file is being written and the job in which its your input has same format specifications. 3) Try to view the data from the input stage. 4) If unable to veiw data. Try to...

Hi, I am getting the following warnings when loading from a sequential file to a table. None of records are loaded into Table. The file is generated in the previous job, which i am using in this job. Can you please tell me why is this happening. Am i missing anything here. Sequential_File_79,0: Fiel...

It's not clear what problem you are having. For the orderlines info, you should be receiving two rows out of your xml structure.... which elements are being duplicated incorrectly beyond that? Outside of xml, what kind of a config file do you have? Are you running everything sequential with single ...

Hi, I have a parallel job: External SOurce-->XML Input-->Transformer--->Dataset. My XML input file has two records at the line level. But the dataset is getting loaded twice with the record at first line level. Its not processing the second record. Can someone take a look at this. i have /order/orde...

Ok...first of all, let's make sure that the technique in the "original" issue is fully understood. This is where the column FRED was suggested. The goal is to get you comfortable with the repetition element concept... I hope it was clear. You should have received two rows, as you confirme...

jatayl wrote:I'm not Ernie, but I would use <OrderLine> as your repetitive key.

I tried but it didnt work out.
same row is repeated twice.
my "FRED" XPath Description is:
/Order/OrderLines/OrderLine/

Is there any other way...........

jatayl wrote:I'm not Ernie, but I would use <OrderLine> as your repetitive key.

Thanku for the reply...........I will try that and reply back soon.....

Just follow what I put in the entry above. Try it in a simple test. Have only one column on your output link.... call it "FRED". Make it varchar and length of 300. Put the xpath above "as is" into the Description. Make it the key. Send it anywhere. If your xml is truly as you ha...

Below is the XML file: My key column is ReceiptLine ItemID="10000801" I have enabled Repetion key in enabled...... Please let me what i m missing in the construction. <Receipt DocumentType="0005" ReceivingNode="Innotrac_H" ReceiptDate="" ReceiptNo="20080...

Why are you bringing all your data in through the folder stage? Why not just the filepath, and then chose url/File Path radio button with the filepath as your input field in the xml stage? Did you try making ReceiptLine your repetitive key? [/quote] I have redesigned my job.... Folder Stage---XML I...

Just follow what I put in the entry above. Try it in a simple test. Have only one column on your output link.... call it "FRED". Make it varchar and length of 300. Put the xpath above "as is" into the Description. Make it the key. Send it anywhere. If your xml is truly as you ha...

just tried it. Worked like a champ. Two rows as expected. Ernie Hi Ernie.. Do i need to create a new column in the Transformer stage and pass it to Target. I could not able to solve the issue. I tired creating a new column in transformer stage and pass it to sequential file. But that didnt work.......

HI I have a job reading from XML and loading to a Sequential File. My job design looks like: FOlder-->XML-->Transformer-->Seq File. I am able to load only one record. Multiple records are not getting loaded. Below is the XML file: My key column is ReceiptLine ItemID="10000801" I have enabl...

If it's that simple a job, check your xpath.... (Description property on the noted columns in the output link of your XMLInput Stage)..... One guess is that the columns simply aren't in the link... (could be that they weren't in the referenced XML instance doc that you used for meta data import). A...

Hi Source: XML FIle Target :Sequential File Processing Stage: Transformer. I have date fields in the below format. These fields are not getting populated into the sequential file. The job is runnning fine. Let me know, do i need to use any date conversion here. datatype is date from source and targe...