DSXchange

HI All I have csv file containing the data like this Electrical Equipment,ElecEquip "Engineering, Machinery & Equipment",Engineerin Entertainment & Broadcasting,Entertain The first and third record are fine,The issue with secod records as it has comma enclosed with in inverted comm...

Just try changing NLS in the file to none

HI All We are using 7.5 version of Datastage Server Edition. In datastage Administrator we set the Enviornment variables as Name Type Prompt Value SAP_DATABASE_PAR String SAP Database AAA SAP_USERNAME_PAR String SAP Username BBB SAP_PASSWORD_PAR Encrypted SAP Password **** and we used these variable...

If you see the Director log

SAP_Database_Par=
SAP_Password_Par=LL:@1;V@N93L0O4I<;JM3KIFB<>MM0
SAP_Username_Par=

You cans see the balnk instead of default vaues
The Error " User Id is a required stage property".

I changed the values in Datastage Administrator

HI All We are using 7.5 version of Datastage Server Edition. In datastage Administrator we set the Enviornment variables as Name Type Prompt Value SAP_DATABASE_PAR String SAP Database AAA SAP_USERNAME_PAR String SAP Username BBB SAP_PASSWORD_PAR Encrypted SAP Password **** and we used these variable...

HI All Iam trying to improve the performance if existing ,In the job there are few direct OCI lookups like this . SELECT PLT_FROM, PLT_TO, PLC_ID, PLC_DESC FROM STA_PROD_HIER_3 WHERE PLT_FROM<=:1 AND PLT_TO>=:2 If i remove and do Hash file lookup iam not getting the results as desired. Could anyone ...

Hi All, I have sequence of jobs which takes current date as ap parameted to run. and once those sequence of jobs complete i need to updated the end datetimestamp ,i tried using a shaned container which will pass sysdate and time from dual and updated the table ,but when the job completes i can see t...

The file which is causing the issue contains 700000 records..

But what is the issue with the existing script ,it work fine when the file is is smaall,its is throwing this issue only whenthe file is big..

HI! All Iam running this script for splitting the file in command stage ,attacth a timesatmp to it and then conver it to .tmp extension cd /home/staff/thussain Prefix=Z_PRICE_NEW_`date "+%Y%m%d%H%M%S"` split -3000 -a 5 /home/staff/thussain/Z_PRICE_NEW.txt $Prefix find . -name "$Prefix...

HI! All My Source is Oracle table ,iam writing in to Hash file the source data ,when i run this job individually its working fine. when iam triying to run parallely with other jobs the job is throwing this warning "EdwLongLangDescriptionsJob..HF_GPWDescriptions.IDENT1: ORA-01410: invalid ROWID&...

Selecting the maximum records and group by on two key fields are types of aggregation we are doing .

HI! All Iam facing a problem with aggregator stage in my job,Ian selecting a records from source and doing a group by with two key fileds and aggrergatting with max() function with the rest of the fields. The JOb is working fine when the record count is below 8 lakhs ,if the records count is more th...

HI! All I have a shell script Sample.sh,when i try to put this script in Exec Sh option in Job properties iam getting an error "cannot find Sample.sh the script is working fine when i run from the particuar folder where the script resid i tried to execute the script this way home/staff/thussain...