DSXchange

Hi,

I have taken the premium membership for one month,

But still I am not able to see the premium member contents.

I have attached the invoice for reference

Please let me know the reason.

Regards,
Partha

I have to process multiple XML files with same schema having optional element fields and some fields having multiple roots, is it possible to implement this in Datastage. I have pasted a sample screenshot for the column FundID which can be available in different roots and I have to take only one val...

We are facing an issue while loading a delimited file into sql server database. The metadata is defined in schema file as mentioned below. record {record_delim='\n', delim='|',final_delim=none, quote=NONE} ( Col1:nullable string[1] {null_field=''}; Col2:nullable string[5] {null_field=''}; Col3:nulla...

Hi, We are getting this error in datastage parallel job in windows platform. We are reading a 8 gb file from sequential file stage and split the records in two flow. In one flow we are assingning inrownum for each records in the transformer stage. The mode should be in sequential mode as we want to ...

Actually In production the job is getting aborted due to not doing the Null handling. But the same job is working fine is Dev and QA server(Without any Null handling). Trim( Convert('"','', ToXfmTrm.col1) ) There are four columns for which this error is coming. These columns I am taking from fo...

Hi I am getting this below error for a job.The columns present in the job are nullable only. If I am doning the null handling in the below way then the below error its giving. If (IsNull(column1) or TrimF(TrimB(column1))='') Then '****' Else TrimF(TrimB(Convert('"','',column1))) APT_CombinedOpe...

The files that we are generating in datastage, is it possible to encrypt them before sending it to downstream.Actually we are generating some .txt file windows environment.Now the users wants those files as encrypted to maintain tha data level security.

I need to validate some source files with a single file which is having the details of the source file for e.g file name and record count of the source file and only the correct files will be processed for the next level.How can I implement the same in datastage windows environment.

The requirement is like this. We shall receive files from different source systems as encrypted (key protected). It can be multiple files combined in a single encrypted folder or individually encrypted file. We need to decrypt them (file and folder both in our environment through datastage and then ...

Could you please provide the detail information regarding this?
We are using windows platform and to achieve it what are the steps we need to follow, once we install the software what stage we need to use to develop the same.

I need to decrypt some files in datastage which are coming as encrypted from the source system and also after generation of new files and sending them to other location I need to encrypt them again and then need to send. Can anyone help me how can I achieve it in datastage in windows environment.

The output columns are restricted and the no of distinct dates for a particular account no will not go beyond that.

yes, Acct1,Date1 Acct1,Date2 ... Acct1,Daten in multilpe rows for the same account no i.e. there are multiple date vales for a single account no , and we need to take sort the date and then min date need to go to dat1, next one to dat2 and so on in different target columns for the same account no.

If for a account number there are multiple values are present in another field, how can I take each value and propagate it to different fields.For e.g. if there are multiple dates for a single account no coming from a single source field,and in the target there are different target columns are prese...

If for a account number there are multiple values are present in another field, how can I take each value and propagate it to different fields.For e.g. if there are multiple dates for a single account no coming from a single source field,and in the target there are different target columns are prese...