DSXchange

Thanks Craig. It helped.

Hi,

I need to get number of days between two dates in transformer. One of them is having format: 12/25/2009 and other one is like 1/21/2000 12:00:00.000000 AM.

Basically I need to implement TRUNC(DATE) functionality of Oracle.

chulett wrote:Escape the quotes. What actually works seems to vary with people and their specific version, but the first thing I'd try would be the standard "" if "quoting the quotes" didn't work for you.

Could you please explain a bit more how did you achieve it?

ray.wurlod wrote:

Code: Select all

Right("00":MonthFromDate(InLink.TheDate) : "-" : Right(YearFromDate(InLink.TheDate),2)

...

Ray,

Should we use:

Right("00":MonthFromDate(InLink.TheDate),2) : "-" : Right(YearFromDate(InLink.TheDate),2)

??? as the requirement is MM-YY?

Hi,

This topic has ben marked as resolved. Could you please tell me how did you resolve it?

chulett wrote:Space issue?

Hi Craig,

I was just wondering how did you identify that it was a space issue?

Just declare "dollar_cd" in the input link of the transform stage with the appropriate data type length and then you can work with that column, assuming that it is being delivered via RCP. You can che ... Hi Arndw, Do we really have to declare it again as we already have RCP enabled, so i...

Hi,

You have marked this topic as resolved. Could you please let us know how did you make sure that deadlock situation doesn't come?

got it

thanks!!!

I think merge and reject would do it.... I am not sure why funnel ad aggregator are needed.

Thanks for clearing my doubts !!!

Hi, Suppose I have data which has 3 columns - emp_id, emp_name and mgr_id where mgr_i is emp's manager's id. I need to know how many employees are there who does not manage anyone. One approach might be self join but is anybody having any idea how it can be implemented in datastage without using sel...

oh

so join uses permanent memory which is also not resource disk?

thanks

Hi All,

If I need to delete a dataset (data file as well as header file what should be given in orchadmin command?

orchadmin rm dataset_name.ds?

would this delete both of them?