DSXchange

Hi All, My job design is as below, External source stage ---> XML Input stage (url input) ---> Data set I have set of XML files in a folder. With the help of external source stage i am reading the file urls and passing it as source for XML input stage. I need the out from XML input stage for all fil...

Thanks for your inputs. I am able to achieve whatever i was trying for.

I have used external file stage to list all the file names and selected the XML document option in XML input stage. It worked.

Thanks.

Hi All, I have to process more number of XML files of same structure. Seq file ---> XML Input ---> DataSet I am using XML input stage. I am planning to use URL/File path option (In XML input stage) and file pattern option for source in Sequential file stage. Can anyone help me how to use both the op...

To add some more details,

Source i have as Teradata. From the error code i can understand it is related to incorrect timestamp issue. But when i pass the smaller values it runs fine.

I checked the source DB it has data for past 6 years. Please help me how to fix this issue.

Hi All, job: OLTP->Transformer->Flat file We are facing a scenario in the above parallel job when we do a full pull (to_date('#$ABC#', 'ddmmyyyy')-#$XYZ#); when we pass 10 or less to XYZ, the jobs runs successfully, but when we pass in higher values like 500 or 1000 the job aborts with the error &qu...

Scale of the column is actually set to blank. Not sure on how/what to set it, as only the length of the column as been changed. We also tried with odbc connector instead of oracle connector and recieving the same error. Job is finishing successfully in Development, but failing in Certification envir...

Thanks for the input.

But, Currently the setting is "No" for Fail on size mismatch and still we are facing the issue.

Hi All, We are having a parallel job which gets data from a DataSet and loads into oracle table. Dset --> Tr --> Oracle connector The job was running fine. We had a change in a filed length from NVarchar(100) to NVarchar(525). After we had this change in DB for varchar filed we are having the issue....

In designer, select advanced in Find options there you will get options for last modified.

Thanks for the inputs.

Stringp is typo error.. Will check the docs and will update the result.

My Java code is:

Public class Print_ds
{
Public static void main(Stringp[] args)
{
System.out.println("Success");
}
}

Hi All, I am working with Java client stage to invoke a java class file. I am just calling simple class file to print a message. My design is Java client stage -> seq_file I am not returning anything out of my java class. In the link to seq_file I am just having one filed but I am not passing throug...

Sorry, Forgot to mention it.

I am using Import-> Table Definitions -> Plug-in Meta Data definitions -> Teradata.

Hi, I too have faced similar kind of issue: http://www.dsxchange.com/viewtopic.php?t=146573 when I tried to import a teradata table which do not have primary index it is not listed in import definition. I have full access on that DB. Please let me know if that is a bug and any workaround for this. W...

Hi, I too have faced similar kind of issue, http://www.dsxchange.com/viewtopic.php?t=146573&sid=969b7fd5eaea2218f586689dec1ab543 when I tried to import a teradata table which do not have primary index it is not listed in import definition. I have full access on that DB. Please let me know if tha...