DSXchange

We are trying the change some element value in datastage job xml export through a datastage job. In XMLInput stage we are confused with the Key column selection. Please guide us which element is the best candidate for key column for datastage xml. Please refer the DTD below <!DOCTYPE DSExport [ <!EL...

Hi,

Can any one please help me to know the teradata stage equivalent to the following oracle stages

1. Oracle enterprise stage
2. Oracle OCI Stages
3. Oracle OCI Load Stages

Many Thanks
MSR

Hi Ernie, scroll to the right on the link... add "text()" to the end of each of the strings.... Ernie Will that work for a parent element which don't have any text. Below is the XML I have used <?xml version="1.0" encoding="ISO-8859-1" ?> - <note> <to>Tove</to> <from>Ja...

It won't be that simple, I'm afraid. You could test that process out by exporting one job as a control, then manually changing the stage to Teradata and exporting it again, comparing the two exports. You'd need to quantify the exact differences between the two and see if you could come up with some...

I'm new to XML stages. Need your help for the following. When I use MS Excel to import the XML I got the element name by default for parent elements. But in datastage we got the full tags.Is there any way we have to extract the element name instead of tags?. Note: In XML document on XMLInput section...

We have nearly 600 datastage jobs in which the target table & target lookup tables are Oracle EE stages. Now we need to fork lift the Oracle database to teradata. Is there any other way we have other than opening each & individual job and changing the oracle stage to teradata stage? Before s...

Hi,

We have target file stage which writes to a CSV. We are getting box ch '[]' at the end of the file. How can we remove this? Please help

Thanks
rMS

ds_search2008 wrote:In the transformer stage use SetNull() against the corresponding null fields and in sequential stage Null Field Value should be set to '', meaning Null Field Value =''.

Regards

Nope. It doesn't work out. I still got the error message

muralisankarr, You can fix this by Nullable properties in the sequential file column tab. Meaning, in the column tab click on the number against the corresponding column "Edit Column Meta Data" window will open. Set the "Nullable" properties accordingly. Regards Hi, For the foll...

arvind_ds wrote:Do null handling for said columns in the transformer stage

Nope. They are simple one to one mapping

Look in to Vincent blog. It may help you

http://it.toolbox.com/blogs/infosphere/ ... tion-11163

Hi, A Simple 'Oracle Enterprise-> Transformer -> Sequential File' job has given me the below warning message. Sequential_File_1: When checking operator: When validating export schema: At field "SALARY": "null_field" length (0) must match field's fixed width (10) Sequential_File_1...

Pagadrai wrote:
Hi,
Have you given a valid server name?

Hi,

Server Name - Is it oracle connection string you are pointing ? If so I have given it correctly
(Sorry to ask such a silly qus. I'm new to PX).

I have imported a oracle table having following columns in an ODBC stage Salary => NUMBER (8,2) Commission => NUMBER (2,2) When I executed the job, I got the following warning " When checking operator : When validating export schema: At field "Salary" : "Null-field" length (...

I want to use a Oracle Enterprise for a source. When I attempt to do so, I got the following error

Missing server name : Can't connect
APT_OraReadoperator : Connect failed


Please help me to sort out this