DSXchange

This question has been answered several times and do a search and you will find that, Interview Questions are not answered in DSXchange.

Hello All, I would like to express my sincere thanks to all the posters and the members of DSXchange.. This is indeed one of the best place for DS developers to interact with the experts who never mind answering the posts .. Appreciate it ! There is no words to explain about the contribution of the ...

Thank you .. As you rightly pointed out, believe something is wrong with the xml document..looks like it is edited manually... Am able to open it in IE... But I was not able to import the metadata of it.. I have sent it to review it again.. If am able to import the metadata, then retrieving the colu...

Create a sequence with three job activity stage for each job, and then in trigger tab mention ( expression type-> 'ok' )

Hello everybody.. I have a job which has a xml file as input that loads data into multiple tables. Now, the file we receive comes with few other tags also which we have to ignore. eg: <ns10:myAssetDetails xmlns:ns11="xxxx:xxx-xxxxx:vs.2001-10-01" xmlns:ns14="xxxx:xxx-xxxxx:vs.2001-10-...

chulett wrote:An 'always on' WISD/RTI/SOA job would do that. ...

Thanks craig. Where can i read about "WISD/RTI/SOA" jobs? I do not see in parallel job developer guide.

Thanks.

ray.wurlod wrote:It's not usual. ...

Thank you ray. What could possibly made the job to restart again? Any property to be set for this?

Thanks.

Hello all,

We noticed a strange behviour in DS job today. We were restarting the target database(sql server) when the job was running. The job aborted and immediately restarted. Would like to know whether it is a usual behaviour of DS to understand that connection got lost, and re-run again?

Thanks

Hello all, I am loading data from a table into two databases. Both the source and target is MS SQL Server. Here is the error I get when the job runs, APT_CombinedOperatorController,0: Fatal Error: [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]SHUTDOWN is in progress. Is it a network probl...

Yes, correct. I have used 'Final Delimiter String' proerty only, and it doesn't seem to write 'ABC' in the end. Tried giving ABC in single, double, and without quotes and it doesnt get added in the end of the last field.

Any ideas on this?

Thanks.

Hello All, I am trying to find the right usage of string as Record and Final Delimiter. Here is my input: Name,Country Jane,US Rick,Europe Tenny,India John,UK I do not have problems in reading it. I am trying to use different delimiters while writting it. How do i specify that i want 'ABC' as Final ...

Ravi.K wrote:Finished -- Job finished without warnings.
Finished(See log) -- Job finished with warning and "See Log" just alrets you that there are some warnings.

Thank you Ravi !

Hello All,

I would like to know whether there is any difference between the job status 'Finished' and 'Finished(See log)? I could note that most of my old jobs show the latter status.

Thanks.

We can use copy stage when we want to load our source data into multiple targets, and when store stage does not support multipe links.

chulett wrote:

Harini wrote:Still, the data is getting loaded with the zeros in the database.

No, it's not.

As noted, that is an external representation of the internal value and the viewer is "adding" the zeroes. Trimming the zeroes is a waste of time.

Thanks everybody !