DSXchange

Ok, the above error is when, I try to mark of the Field (Sino) as Key. Else I get the following error. XML_Input_20,0: Error: No repetition element specified for link "DSLink22". Please make sure a column that contains the repetition path is set as key in the output link table definition. ...

Hi, Iam finding difficulties in reading a simple XML data. Let the following be the data. <?xml version="1.0" encoding="ISO-8859-1"?> <EMP> <Record sino="1" name="Mark" sal="100.00" /> </EMP> The metadata got imported properly. Job design is as follo...

Is it the part of Version 8?
Is there any documentation avaialable regarding the functionality and performance boost that we get in V8 if we upgrade?

Yes. Load the summary data into the Hashed file. Mark nall the 11 fields as Key. Do a lookup on the Hash file.And extract and join the rest of the fields.

Thanks for reply. Is it any dummy row that you refering to as HeartBeat. So we should reject that row with some conditional check isn't? So if we have a Name pipe and make the job to listen to that pipe, will the job always be running, even when the data is not available in that pipe. Coz, the data ...

Hi, My current project setup is as follows. Set of files need to be processed. Though each file is of less number of rows, large number of files need to be processed. So We have set of Perl program to preprocess and get the files from different server and drop in datastage box. As soon as the files ...

Is there any parameter that I need to set to true to get these information in Directory. Because, I dont get this log information at all.

Thanks Kim.

May I know how to specify the Uncommited read?

If you do this then you might lock the records you are trying to update. So the source SQL needs to have the correct options on it. This is my concern. We are in desing phase, and dont have access to Datastage. So kindly let me know, if I read some data from a table, and trying to updated the same ...

My concern is not to enable or disable it. If RCP is enabled, and If I use schema file, which has more columns (by chance) and if the target table as less number of columns in that job... Will it error out or will the columns found in last will be sielently discarded or will the system collapse. We ...

Hi,
We are trying to use RCP.
Kindly let me know, What happens when more column transfered from source through RCP, but less column avaialble in target table?

Hi,
Pls let me know, how to update the source table in the same job based on some condition.

Due to some reason, I could not locate the option to change the Normal lookup into Sparse.
Could you pls help me on locating it.

DSguru2B wrote: ...due to the fact that it uses native drivers than generic ones. ...

Then what is the difference between, Enterprise stages and API stages?

I am not going to run it anyways, I just want to know why its recomended in such way. And like to know the architecture of Datastage on MPP.