DSXchange

FIrst of all Let me thank you for a prompt help, to keep it simple ,my file name is xyz,it will never change, if the first file xyz is having more than or equal to 1 record,then fine else(ie if the file xyz has zero records),then I should produce a file with same above name xyz,but this time the for...

Hi One of my job's o/p is seq file xyz.csv, My req is If the o/p file xyz.csv is empty,then I should be able to generate same file xyz.csv with another field format xyz.csv field format(K1 is field name) ----------- K1 new file format xyz.csv(If the above file is empty then it should be in this form...

Hi
I already searched for Preserve type,But in 7.5 server edition,I could not see that option

thanks

Hi Can you tell what is ur input and what is the out put u want
if possible quote an example

HI Can you please explain me what do u mean by rounding the px job,
is it any particular field are yoy talking about??
Ray said using Floor function

too my knowledge it is used for a prticular field

please lemme know

thanks

Hi, Using the left and right string functions in combination,we can reach the exact string position/extract that bit of required string and I have a question here, declare the columns appropriately in the sequential file stage and save reconverting them in a transform stage. where in seq file is pos...

Hi orchadmin command followed by filename 1)better to write a program in which pass the filenames as operators 2)or in the datastage ->designer->tools->dataset management->go to the path and select the dataset and delete it 3) To flush the dataset develop a job in wchi src is row generator and put t...

try with like'xx' instead of ='xx'

Hi I am assuming the datatype as varchar for the column IM_ITEM_NBR please confirm did u try executing in oracle,if u get out put then in ds also is should not be a prob please send a few records with data I guess the problem is with the kind of data the table has put the condition IM_ITEM_NBR <> 'x...

HI
1)I would like to always sort the data before the aggregator stg,
2) use join if possible
3) if ref data is more select the option sparse
4)Using Look up file sets give better performance results
5)properly using partitioning wrto stg and data req
like try using entire with look up stg,

thanks

HI
1)I would like to always sort the data before the aggregator stg,
2) use join if possible
3) if ref data is more select the option sparse
4)Using Look up file sets give better performance results
5)properly using partitioning wrto stg and data req
like try using entire with look up stg,

thanks

Hi All, While performing agg on key col, I would like to take few columns to next stage In that few cols,I have varchar col, SO I tried to make max or min of that varchar col and populate further I am getting a warning saying trying to convert string to decimal............... My intention is to take...

Hi All
Thanks I got It

Hi All
the error is as follows........


PS_NW_DBALEAA_F_SF: Indexes on table 'PS_NW_DBALEAA_F_SF' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.

PS_NW_DBALEAA_F_SF: Indexes on table 'PS_NW_DBALEAA_F_SF' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.