DSXchange

Hi I need a feedback on job design Where I have a requirement to compare two Rows between two datasets and return all rows from one dataset indicating which one matched. . Example Datasets A Id code 1. 1640. 2. 1427. Datasets B I'd. First code. Seccode. Third code fourthcode 1. 1427. 8200. 8000. 500...

Hi

I have requirement where I load data into target
Without landing data into datasets I have to load to fact table
With 10 lookups and 10million records how can we achieve this

We don't have enough space on dataset directories

Thks

Thank you very much. the sample code is working fine for me.


Thanks,
Ven

Thank you very much for your reply.

Do you have any sample code for Transformer loop and Field function for your suggested solution.




Thanks,
Ven

Hi All, I have csv file as given below and I need to make csv file like example below, so could you please provide me idea how to get it using DataStage job stages. CSV File: EmpId EmpName KeyWords 100 Rick "Update,Delete" Basically KeyWords needs to be put into separate rows as shown in t...

Actually the stage name: DB2 UDB Load stage. Sorry for wrong name.

I am basically creating Datafile, control file and batch file using this stage, so that we can load the data into DB2 table later using this script and data files.



Thanks,
Venkata

Hi All, I am getting the following error when I am running DS Job with DB2 USB Load Stage with create data file and load script, so could you please let me know if you have solutions. DB2 USB Load Stage is creating the issues and it looks to me that some environment variables are missing as per the ...

Thank you Craig,

The following option is working fine for me.

Use the -d option to specify the target directory.


Thank you again.





Thanks,
Venkata

I didn't get any error. It is saying that it is processed.


Thanks,
Venkata

Hi All, I am trying to unzip a file (sample.zip) in Linux server from DataStage using the following command, but it is not unzipping and I am not getting any error. Basically I need to unzip any kind of compressed file. I can go with any kind of options. Please help me on this. ex: unzip /data/sampl...

Thank you for your reply.

This error is getting when use the DB2 USD Load stage to create data file and control files.

First time I am using this stage.

Thank you in advance for any kind of help.



Thanks,
Venkata

Hi All, I am getting the following error when I am running DS Job with DB2 USB Load Stage with create data file and load script, so could you please let me know if you have solutions. Parallel job reports failure (code 256) JVMDUMP006I Processing dump event "abort", detail "" - p...

Hi Craig,

It's OK for me.

I have read online documents since morning as you mentioned, but I didn't find the correct solution so far.

I need to one thing is how to read whole XML file as String.


Thanks,
Venkata

Thank you for your quick reply. I am using XML stage currently. I have read that online document, but they didn't mentioned exactly how to read whole XML file and map to one column. They only talked about retrieving two flat files and composed as XML file and load into DB2 table. In my case, I have ...

Hi All,

I have XML file, so I need to read whole XML file as a string and map to one output column in DataStage. I have tried no. ways, but no luck. Please help on this.


Thanks,
Venkata