DSXchange

Hi, I am using XML input stage in a parallel job to read xml. The xml data contains tags like <Name /> instead of <Name> </Name>. Pleas let us know if it is possible to read it in DataStage using XML input stage?

Regards,
kpavan2004

Hi All , I am using DS 8.7 Enterprise Edition. My Job design for delta processing is as below Seq File --> Join (Reference link is TD Connector Stage) --> Transformer --> Split as per rules like Insert/Update/Close --> Combine and send to target. I am seeing strange behaviour that when i change the ...

Hi, I want to copy a dataset from one server to another server. With Dataset Management utility i can only copy within the server. I tried to do using Unix SCP command but could not be successful as it just moves the descriptor file not the data files. Can i copy it using Orchadmin command to anothe...

Hi Requirement:I have a requirement to get the latest record based on timestamp field. Scenario 1: So i have used remove duplicate stage for this. I have done the hash partitioning on the key column and timestamp field and selected "perform sort" option in the input link of this stage. and...

chulett wrote:Try:

SELECT MAX(COL1) as COL1 FROM TABLE

And see if that helps. Make sure the "as" column alias matches the name you've given the column in the stage.

Thanks very much Chulett. It solved my problem. :D

Hi , I am using User Defined SQL while extracting data from Teradata Table . In the sql i am using aggregate funtion max(). When i run the job i am getting the error message "Unrecognised SQL statement" . Can't we use aggregate funtions in Teradata API Stage?. Or Else do we need to use agg...

Using data sorted on the join keys is particularly fast and is also light on memory usage since only the data for a key grouping must be kept in memory during processing. Thanks ArndW for the helpful information. So as per my understanding even join will store the data in memory but in join only st...

Hi, As per the parallel job developer's guide join is preferable over lookup stage for large volume of reference data. I have below query . 1. How it process the large volume of data so fast? As per guide "A join does a high-speed sort on the driving and reference datasets" so is this the ...

Hi,

Can anyone explain me what are the differences between Datastage architecture of Versions 7.5 ,8.0.1 and 8.1.

Please also let me know where can i get the clear information on Datastage archictecture.
Thanks in advance