DSXchange

Hi Everyone, I am using a surrogate key stage in my job. This is the properties in my surrogate key stage: Database Type - Oracle Oracle Server Name = xxx Password = xxx User Name = xxx Gerarated Ourtpu Column Nam = sk_Facility_ID Source Name = Schema name.sequence name Source Type = Database Sequen...

... which means there are no 'extra' pipes in your file and thus my suggestion should have worked just fine as well. Craig, Yes, my assumption is, there is no extra pipes, if there are extra pipes, there is still a way to get around, this is what I think, step 1. remove all #'s step 2. replace all ...

This is my solution in the end, I wrote a simple shell script to remove all quotes in the incoming directory, then use to sequential file stage to read all *.new files, after jobs are completed, remove all *.new files. Per suggestion from Ray, yes, Server may work, but I want to use the "file p...

If you want to try your luck with a 3-character delimiter like "|" (might work if you don't have a pipe at the start or end of your record), then you need to use the delimiter string property. The delimiter character property is limited to a single character. Mike Mike, I did use delimite...

I would think that you could tell it that your fields are not quoted so they come in as data and then you can trim off only the leading/trailing quotes. ... Craig, That is what I thought, but it looks like the sequential file stage does not take "|" as a delimit string. whenever I hit ok,...

Is it possible to have "|" as the delimiter string? I tried that but the sequential file stage does not take it.

This is a little bit strange because I have no problem parsing the file using Excel, by doing a text to column.

Good evening everyone, I have a simple parallel job that reads a PSV file, that is, Pipe delimited file with double quotes, here is a sample "aaa"|"bbb"|"ccc"|"dddd" "eeee"|"fffff"|"ggggggg"|"hhhhhhh" but the job skipped...

Hi Everyone, Thank you very much for the suggestions. I have an update on this, I split the job into 2 jobs, the first job writes to a dataset, and the second job reads from the same dataset and load into the Oracle enterprise stage, guess what, no problem. I really don't know why this happens. Hi E...

Hi Everyone, Here is a problem, I want to do a destructive load, that is, delete all, then insert, in the oracle enterprise stage, I have Write Method: Load Write Mod=Replace but it does not delete, only inserts. Can anyone let me know why? by the way, I build a server job doing the same thing and t...

I started working on Datastage in 2002, I am not sure how bad the market will go this year , but so far I am more happy in 2009 than 2002. A friend of mine ( not myself, ok ) told me he got laid off from Ascential back then and it took him nearly 5 months to get a contract.

Hi Everyone,

I am planning to install datastage client on linux ( ubuntu 8.04 ) with wine. DS server is running on solaris. Has anyone tried this in the past? is Datastage 100% compatible with linux+wine?

Thanks.

Hi Everyone, I am getting this error message when I run any job in this project, I am also getting this message when I tried to view any sequential file, however, other projects on the same server do not have this problem. Do you know what's going on? Thanks. DSD.SEQOpen An NLS map (ISO8859-2) has b...

Hi everyone, I need to ftp a csv file, the delimiter is a #sign, and the file comes with a one line header, and there is no empty row between the header and the body. like this, #header# a#b#c#d#e#f#g a#b#c#d#e#f#g a#b#c#d#e#f#g a#b#c#d#e#f#g a#b#c#d#e#f#g a#b#c#d#e#f#g I am wondering, is there any ...

Good morning everybody,

I need to have multiple links writing to the same target, the target could be a sequential file, afileset or a dataset. is there anyway I can do it without using a funnel stage?

The entire file has more than 2 million characters. I use an xml input stage, and the xml source is 'xml document'. I saw your message earlier this morning , so I changed the source to 'url/file path', But I am still getting the same error message. This is the error message: FBuilder_DTD_test.#0.get...