DSXchange

ray.wurlod wrote:Yes. Once you have your premium membership you will be able to join them.

I am sorry Ray but I didn't get what you meant by "you will be able to join them".

I was simply asking if anybody is aware of exact difference betwen these.

And what options i need to set to specify that this particular value would come at run time from parameter?

thnx anbu,

can u pls tell me how do i exactly make parameter out of this command? is it using exec command stage?

Hi,

I have an input file whose number of records keep on varying. I need to capture these number of records and assign it to one column. how can I achieve this?

Is anybody aware of what is the exact difference between macro, function and routine in data stage server jobs?

Because... they're not? Seriously, not really sure what kind of an answer you were expecting. The two products have completely different origins, philosophies and architectures so the vast majority of the stages specific to PX wouldn't really apply in the Server world. Common ones do, of course, li...

chulett wrote:No. It just means that if it does have quotes, they are doubles. It doesn't mean that quotes are in some way required to be in the file. ...

Thanks Craig!!!

Seems like you are trying to nonstring value as string

Why it is so that we do have some stages in parallel but not in server? ?Parallel jobs are meant to use benefits of parallelism but and running them as server job might not give that benefit. Bu still why they are not available at all?

anbu wrote:CSV file without quotes and CSV with quotes will be read properly by using your format setting

Anbu,

Isn't quote= double would affect the sequential file which is not having quotes?

if not, why

Sequential file can be used in lookup as reference. What do you want to know? Thanks Anbu. What exactly is a difference between file set and a sequential file. I have 5 sequential files which I need to use as reference for one input only. One option is I can append them to each other and make one l...

Hi All,

Has anyone ever used a sequential file for look up as reference table?

chulett wrote:This should help.

Thanks Craig!!!

So it means we define unicode character set only when either we have NLS enabled or data s being transferred between two sources which might have different native character set.

Correct me if I am wrong.

chulett wrote:Which is short for 'Unicode', btw.

Thanks Craig. What is this unicode language? is it the one used by OSH script?

What is the difference between string and ustring?