DSXchange

Dear Experts, We are using BW_Load_Stage to load data from a table to SAP BW. All the required configuration are done and able to connect to SAP BW through BW Load Stage but unable to see Info source created in SAP BW whereas able to see system defined transaction Info source type (Starts with 0 and...

Hello, Need clarification on Array Size option in DTS Stage. Our job design is to read messages from queue, parse it and load the transaction into the target tables. DTS stage is used to ensure transaction control. The query is to understand if we give a value of 2,000 for Array Size , does it signi...

All, We are running MQ connector in multinode (4 nodes - Conductor/Compute Configuration). The purpose of this job is read data from Source Queue, move to work queue and transform the data from source queue. In case of any failures the data from work queue will be moved to source queue and job will ...

The file is creating as UTF-8 if I pass some UTF-8 special characters. I am still not clear why the same is not happening when we pass normal characters which is again valid UTF-8 characters. Any thoughts?

Thanks,
Senthil

Hello Mike,
Thanks, I will check on this and get back to you.

Thanks,
Senthil

Thanks, its still the same. I have explicitly set the exrtended property across all the stages, still the output is in 'ASCII TEXT'. I assume the setting given in the stage will overrisde any setting given in Job/Project/UVCONFIG. In stage/job/project the NLS is set to UTF-8. The reason is, when I c...

The problem is not resolved, I have responded to 'chulett' question. The issue is, I am unable to create a UTF-8 CSV file in the target. Even I have tested this with a sample job with Row Generator and Sequential file stage. Is there anything I am missing? UTF-8 is set at project level, job level......

Thanks for your response, I tried a sample job as the original job which transforms the XML to a CSV file is quite complex. For the sample job I have moved the file created in windows setting encoding type as 'ANSI' and moved to AIX using FTP client in binary mode. I am able to see the format as ' A...

Hello, I want to convert the sequential file from ANSI to UTF-8 format. I have tried setting the NLS MAP to UTF-8 at the project level and the NLS MAP at the stage level is also set to UTF-8 just to make sure. The record delimiter is set to UNIX Newline. The file is not geting created in the UTF-8 f...

Excellent, thanks the content is loaded as a single message.

Thanks, I had a similar thought but I didn't the execution option (Advanced tab) where we change the mode Sequential/Parallel in MQ connector. Even I have tried changing the execution mode to Sequential in transformer as we have a transformed stage before MQ connector but no luck. Can you please hel...

Thanks, I had a similar thought but I didn't the execution option (Advanced tab) where we change the mode Sequential/Parallel in MQ connector. Even I have tried changing the execution mode to Sequential in transformer as we have a transformed stage before MQ connector but no luck. Can you please hel...

Hi, Appreciate any help on this! When I use a multi node configuration file in DataStage the message in MQ is getting spilited into multiple chunks depends on the no of nodes given in the config file. Is there an option wherein the message will be loaded as one single file though we use multi node c...

Hi, I want to truncate the target table only when the record comes from source system. My source table is in oracle database and target database is in DB2. The requirement is to move the record from source to target if record exists in the source tables, if no record exists in the source then we nee...

Hi, Thanks, Is it possible to pass more than one more config for each job? Currently we are defining a parameter set with different set of config files and pass the appropriate value through sequencer activity. In the same transform job I need to use both the dataset created using config file 1 and ...