DSXchange

Thanks Criag, For each person there may be more than 50 states and one more thing is we get the data in a fixed witdh file and the data for the state field comes with a comma seperation, So I have loaded the data into a table in the above menctioned way, from there I am trying to pivot for the state...

Hi, I need to pivot the data which is in a table column in the below way: INPUT Name Account_No state Ram 123 CA,NY,MS Pam 857 IL,KS OUTPUT Name Account_No state Ram 123 CA Ram 123 NY Ram 123 MS Pam 857 IL Pam 857 KS Can please some one help me how to achive the output. Thanks in advance.

Then I would suggest you play the client uninstall/reinstall game again. This time, though, take off and nuke it from orbit - it's the only way to be sure: 1. Uninstall the client. 2. Delete any leftover directories from the harddrive. 3. Use 'regedit' and remove all traces of any Ascential keys. 4...

only I am having this problem, and in all the jobs I cant open the oracle stage. I am able to open the same job in another machine with my user id and password.

I am using Datastage 7.5.1 and I have a problem in opening oracle stage I have a very simple job with Oracle stage and a sequential file stage.Job is going to extract the data from oracle tables and write it into sequantial file. Now if I try to see the properties of Oracle Stage entire Datastage ha...

I had the same situation. we had a SEQ files which worked fine.i dont know how it works for the datasets. but the filenames should be similar. for eg: test1.A test1.B are the 2 files. so in the file name of properties tab give `ls test1*` and select read method as filepattern this is a bourne shell ...

Oracle_Enterprise_2,1: Unable to insert a record into the table. racle_Enterprise_2,1: Records inserted: 0 Records used for update: 0 Records rejected: 0 Total records: 0. Oracle_Enterprise_2,1: The runLocally() of the operator failed. Oracle_Enterprise_2,1: Operator terminated abnormally: runLocall...

i do have all the privilages required

hi , i had a job with a sequential file and a oracle stage .when i connected to one instance it worked fine.i was able to load data into the table. i had the same job but connected to different instance of oracle . now i am i am getting an error say The runLocally() of the operator failed. Operator ...

hi , i have a problem with the performance. My source is a csv file and it loads into a oracle database. we have a 100000 records only daily basis. It is taking a quite long time to load these files. the number of columns we have are 15. please le tme know if any one can help me. thanks in advance