DSXchange

Hi!

can any one throw their experiences, in migrating the existing Orale based DWHS to teradata

ETL used Datastage,

Best approaches , or will be good if some one can help on documentation

Thanks

Hello!,

I am looking for extraction of Business Rules from Transformer Stage.

Is there any way to extract it from a given job or jobs to external file.



Thanks in advance.

Yeah, I am not facing problem with readmethod, the problem is while reading xml file. It is asking for record delimeter. I have checked all the permetations and combinations. Throw some light if you have come across those problem any time. I hv given 2 columns, in the output for sequential stage. 1....

Hi!, Can any one throw some light on the below: I have designed a server job using folder stage, as i need to read xml files from the source, transform it and generate target xml file. It looks something like below: Folder -> XMLTransformer ->XMLinput ->Transformer -> XMLoutput, it is working fine w...

I have designed a server job which is working fine. as below Folder -> xml transformer ->xmlinput ->Transformer -> xml outout I am trying to design the same job in PX EE using squential stage. in place of folder stage. it give the following error: Sequential_File_19,0: Error reading on import. Seque...

I have added an empty field with the xpath in the xmloutput
but it does 'nt work.

If we hav 2 records in a generate xml file for the same invoice.

Header and summary should not repeat for the second record .

Thanks

Hello!, I am reading xml file , transforming it and writhing as xml file using xml out stage. Sample xml out file is given below. Job looks something like this: Folder stage - Xml Input - Transformer - Xml Outstage. Requirment is to generate header & detail relationship . by eliminating the dupl...

Yes I am able proceed and need to check with accuracy of data. Hello, I am trying to read a xml file in sequential stage PX with two columns (Filename and Record).It is not able to read/ It gives the following error. Sequential_File_0,0: Consumed more than 100,000 bytes looking for record delimiter;...

Ernie,

Thanks for your extended help. I have tried in server job it is working and need to checke the record count.

Thanks a lots

I am reading from xml file on to input stage. But no rows are populated on to output stage.

Can any one tell what could be the problem.

Metadata is imported using xml file.

Tried to check with and withiout namespaces.

Both give the same output.

Job runs without error.

I have removed the Dash (ie ,NAXMLBusDoc) from the source XML and tried to import the columns and check.

But still data is not flowing through.

Is there any thing i need to set other than this.

Thanks in advace

So I can try it by changing NAXML-BusDoc to NAXMLBusDoc
and removing making the xpath also NAXML-BusDoc.

Am i correct as per our discussion thread

Hi!, Here is the XML File and Name spaces that i have declared. [b]Name Space Delcaration :[/b] xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:defns="...

1. It is Reading the File from Folder Stage.
2. XML Input Stage , Metadata is imported from XML File .
3. But no out is generated.

XPaths are the same that are generated from xml file while loading the columns in output.

Does xpath differ from the originally generated from import.

Kindly help

Hello!. Can any one throw some light on 1. Are table definitions imported from XML or XSD File ? 2. When i import metadata for output column definitions i am getting prefix of ns1 or defns, is it the correct way of importing. 3. Data is not moved from xml input stage to sequential stage in job Folde...