DSXchange

dsdoubt

Thanks for the input. But how to find that?
What is the exact command you referring to?

dsdoubt

Hi, Using dsjob command, how to find the logs pertaining to the current run alone. When I use dsjob -lognewest ProejctName Jobname FATAL it gives the latest available fatal message irrespective of runs. So Iam also getting message from previous runs. So, how to check the events only for the current ...

dsdoubt

So there isn't any way to read the Fixed Width file with respective data type for each field other than CHAR datatype?
If I mention "Record lenght = Fixed" I cant use Varchar not Inteter nor Decimal. Its allowing only Char datatype.

dsdoubt

Thanks for all your input. I am able to read the data using the mentioned method. ie., creating the metadata manually with all the columns that are necessary. And reading the XML file. But now I have one more query. <HEAD> <TRANS cd="2520" no="235" sls_amt="8657.75" tra...

dsdoubt

Even if I try to edit the XML file to the below mode <HEAD> <TRANS cd="2520" no="235" sls_amt="8657.75" trans_cnt="1224"/> </HEAD> <HEAD> <TRANS cd="2521" no="235" dt_of_tx="20080213" sls_typ="MCP"/> </HEAD> I am not abl...

dsdoubt

Hi,
Do you mean to say, if I change the XML as given, I can import different layout at same time?
May I know what is custom Stylesheet?

dsdoubt

I have the XML file with Different layout. It can be identified by the first field. Sample given as follows. <HEAD> <TRANS cd="2520" no="235" sls_amt="8657.75" trans_cnt="1224"/> <TRANS cd="2521" no="235" dt_of_tx="20080213" sls_t...

dsdoubt

Great patience to write whole lot information!!!

dsdoubt

How can we parse the data based on Schema?
If we have a XML schema and is there a way to reject the records which doest fall under given schema

dsdoubt

So far I never selected the SML Source column drop down in the Input stage of XML. Atlast it worked now!!! Thanks a lot guys!!! When I try to cat the file from ExternalSource stage and use "XML Document" option instead of "URL/File Path", I expect it to work. Its reading all the ...

dsdoubt

Hi Craig, I was trying with ls as mentioned in my previous post. Since it was giving out error. I tried to cat it. Any way now I dont need to keep changing that from now. Hi Erine, I tried that too. Still it giving out the same error. Cannot find mandatory property "xml_source_column". Is ...

dsdoubt

Hello Craig, As Iam new to XML, pls bear with me. Is that the Key option in the XML Input stage you talking about? As you could see in the input file, there is no keys as such. Still If I mark first or all the fields as key in the Stage, I get following error. XML_Input_20,0: Error: Cannot find mand...

dsdoubt

I used External Source stage. I passed the file name to the SourceProgram in External Source stage. I also tried to pass ls <subdirectory>*.xml | sort as mentioned by Erine's blog, still iam getting the following warning. XML_Input_20,0: Error: No repetition element specified for link "DSLink22...

dsdoubt

Any inputs GentleMen?

dsdoubt

Swathi, does it worked for you? Any change that you made?

DSXchange

Search found 106 matches

How to find the logs pertaining to the current run?

XML Read with Different layout