DSXchange

Sorry I don't have a premium membership to lookinto can you please help

source xml : <?xml version="1.0" encoding="UTF-8" ?> <root> <ID>1</ID> <ID>2</ID> <ID>3</ID> <UIS>Yes</UIS> <UIS></UIS> <UIS>Yes</UIS> <clubColor>red</clubColor> <clubColor>blue</clubColor> <clubColor>yellow</clubColor> <playerName>Josh R</playerName> <playerName>Jeff K</playerNa...

Hi Friends I am reading an xml file using sequential file-->xml_input---> sequence file Job is running fine but the out put is like all the records are identical I have 422 records in the xml file(source) and when I run this job I get 1 single record repeated 422 times. Any suggestions where I am fa...

Hi Team, I am updating bunch of records in the target but I want to use my own sql to update records using LIKE operator. Can any one help with the syntax. SKU_ID is the key and the below syntax doesnt work if I give in the target stage connector/enterprise stage. UPDATE SKU SET SECONDARY_DESC=:SECO...

Hi

Can anyone let me know if we can retrieve purged logs in datastage.

Currently my project has purge log before 10 days.

Please let me know if there is a way to retrieve.

crystal_pup wrote:Can you try the above and let us know what you see in the director log?

Hi
I have tried both the options

The output is as follows
Output --> Overtime Reporting/Cubes

Hi Andy,

"Overtime Reporting/Cubes" also didn't work.

Hi

I am passing 'Overtime Reporting/Cubes' as a parameter

Hi Ray.

The double quotes for the directory or path doesnt work still the same issue can you please help if there are any other options apart from symbolic link.

I am using an execute command stage passing some parameters

example: Overtime Reporting/Cubes

but my shell script is recognizing only Overtime instead of Overtime Reporting/Cubes value. Can any one help me on how to pass the parameters which has spaces in it?

Hi Friends, I am trying to build a cognos 10 cube through datastage , The cube builds cuccessfully but the time stamp on the cognos for the cube doesnt showup updated. I have used the below command can any one help me on this -l #ud_Cognos_user# #ud_Cognos_server# abc/cbd/exec_profile.sh abc/cbd/cub...

Null value on accessor interfacing to field "OPERATOR_CD" This field is coming from source which is nullable yes and I am moving to the output link in atransformation which is also null yes. I assume this is because I need to include code in the code nullto emapty or ifisnull set null .How...

Hi Team,

I am writing data to files and I want to append sysdate to target filenames is there any easy way who can help me out.

Thanks

Hi Thanks that resolved my problem in accessing xml file but now I am not able to read more than 1 file in a single run. I have selected the option in external source is Source Method = Specific programs Source program = ls E:\ EMP*.xml I want to read all the xml files that start with EMP in a singl...

Hi Team, I am trying to read an xml file using XML input stage. My job design is Job design: External source-->XML_Input--->SEq file Settings: External source: ========== Properties: source Method: Specific program(s) Source program: ls C:\EMP_FILE_Job_Details.xml Format: Record type :Implicit Delim...