DSXchange

Thanks Craig, Below is my batch script which i am running through the Datastage Job which give error. I have configured Keys for dsadmin user however i have got error saying "Unable to locate credentials". This script works as expected when i ran manually on server. @echo SETLOCAL enablede...

Thanks for your responses.

Yes, RT_CONFIG205 was exists and haven't checked I_RT_Config205.

It worked, after restarting the server.

Hi I am unable to delete Datastage Job in one of my Project, It is giving below eerror: Unable to delete the item(s). Delete object for '\Jobs\Feeds\GlobalArtist\INTL305101_ArtistDuplicateValidation' failed.Cannot open executable job file RT_CONFIG205 This error occurred on 03/12/2014 at 17:43 (Stan...

Arndw

Both are in Local disk(s)

Thanks Everyone, I have increased the RMU and Job looks fine. Arndw: ODBC Stage extracting the 21K/Sec and when it goes to the Sort stage it's come down to 16K/Sec. I need some help on increasing the throughput in Sort Stage. I tried increasing the Buffer in Sort Stage but couldn't see any differenc...

You can go ahead with 2 characters as field delimiter. and follow Ray's suggestion.

Hi I have Datastage Job which does Null Validation, Duplicate Validation and finally loads into Dataset. Which takes around 50MINS to complete(27 million Rows). I would like to improve the performance can some one advise on? ODBC Stage --> Transformer(Validation) Sort--> Transformer(Duplicate Remova...

Thanks Mike for your information

Thanks Mike,

Yeah, I have many fields which has nvarchar(255) and few nvarchar(max).

I will check it.

Does APT_MAX_TRANSPORT_BLOCK_SIZE, APT_MAX_DELIMITED_SIZE change the any space issue?

I am Sorry.... if it means in that way. But I would like to know How much space Resource Disk We need to process 1 GB Flat File(CSV), Because I am processing one file which is 30GB which is creating 230GB Files in Resource Disk Area where I have no transformations Just removing the Duplications if t...

Hi I have Data stage Job which process the file has 30GB(14m Rows). Which will Remove the Duplicates and writes the valid data into Dataset. Which is creating 230 GB datafiles in Resource Disk and 200GB temp files in Scratch Disk. Does Dataset Data files become these many time on actual raw files? A...

Hi Is there any way to find the user name which is used to execute the datastage job/sequence??? Because i am trying to execute batch script through datastage sequence. But it was successful and there were no error. I thought it might be access related issue. The script is working when i execute on ...

Hi I have Database table with all Database Names, User Name and Password(Text). I have Datastage Job which creates Parameter Set when i set Password parameter as Encrypted, Job is failing due to password incorrect,it was success otherway round. But i want to make this encrypted. is that possible? Th...

Hi, I am trying to load flat file on to Sql Server table. There is one field which has huge data its almost 2000000 bytes. I am extracting this using "LongNVarchar" data type in Datastage and loading into "ntext" datatype column in Sql Server. I am getting below error when i exec...

Actually there are no missing columns in the job. It displays for all columns in schema file.

This job uses schema file and rcp functionality.