DSXchange

Thanks WAhi80

I am getting following warning in the transformer stage before loading into final dataset

xfm_tranformer,0:Field XXX from input dataset '0' is NULL. Record dropped.

and the output datatype is : Varchar2(52)

In my job i am loading the dataset to oracle thro copy stage in between
i am able to view the data in daset but my job abort saying NLS language is UTF8 is set not used
I also checked in admoinistrator and oracle stage it set correct only

Why it fails?
HOw to et rid of it?

My reqriment is to find the minimum of two dates like (date1,date2)
How to do without transformation?

eg 05/11/2008 05/12/2008


i want output as 05/112008

thanks

is datastage px will take date in format yyyymmdd (20070202) as it is with out any conversion

is there any other way other than routine to convert date from mm-dd-yy to dd-mm-yy in server job

1)i have a sequntial file with date column 2) the next transformer stage i extract the month from date 3) i give it to copy stage 4)from copy stage i link to transformer stage in this stage i split it by month by giving constraints like dslinkname=01 dslinkname=02 dslinkname=03 dslinkname=04 dslinkn...

My reqriment is to split the records by month in to 12 sequentil file.
I am trying to split it in tansformer stage by giving the constarint linkname=01(month)
...up to linkname 10 it is working if i give linkname=11 during compilation it gives error.


thanks
Balaji G

use head stage or tail stage

What is meant by runtime column propogation? how it was used?

I have a text file which have a name column it contains 140000 names starting from alphabe A-Z with duplicate entries it want to load it into files asper the name (ie name starts with A into one file starts with B to another file ...........) in sql we can achieve it by where names like "A%&quo...

Thanks
In server we can use substring. How about in Px?

Hi
I have date column like 20070203
20070912
........the format is yyyymmdd in text file i want to split month only ie 02
09...

How to achive it in parallel? what function should be used?


thanks
Balaji G

i changed default apt_config file when i run the job the following warnings was thrown i think as i changed the default config file it is thrown 1. No disk resources found in "sort" pool or default pool; using /tmp 2. Join_Acct.Acc_Data_Sort,3: No disk resources found in "sort" p...